From: Zabach, Elke (elke.zabachsap.com)
Date: Wed Jun 30 2004 - 02:12:56 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]