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?
