joemoyle wrote: > > I'm attempting to convert from MS SQL to MaxDB. In MS SQL I issue the > following statement before any table creates in my creation scripts. > if exists (select * from dbo.sysobjects where id = > object_id(N'[Language]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) > drop table [Language] > GO > In MaxDB using SQL Studio I try the following with no luck. > IF EXISTS TABLE "LANGUAGE" > THEN > DROP TABLE "LANGUAGE" > When I execute EXISTS TABLE "LANGUAGE" I get back nothing but if > I execute EXISTS TABLE "Joe" I get back the expected -4004 > error. I'm not finding the IF documentation helpful. It has got to be > something painfully obvious I'm missing. Could any of you help this MaxDB > newbie?
In the archive http://lists.mysql.com/list.php?list=maxdb#b I found something. Please see http://lists.mysql.com/maxdb/21152 Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
