Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
AW: IF EXISTS TABLE?
From: Zabach, Elke (elke.zabachsap.com)
Date: Wed Jun 30 2004 - 02:12:56 CDT
> 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]
> In MaxDB using SQL Studio I try the following with no luck.
> IF EXISTS TABLE "LANGUAGE"
> 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
In the archive http://lists.mysql.com/list.php?list=maxdb#b I found something. Please see
SAP Labs Berlin
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb