hi everybody...
i am searching for sth. equivalent like:
MySQL:
DROP TABLE IF EXISTS tMyTable
M$SQL:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tMyTable]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tMyTable]
GO
can anybody help me? as a workaround i tried to create a dbproc like:
CREATE TABLE TESTTABLE(TESTCOL INT)
//
CREATE DBPROC MYDROP (IN TABLENAME VARCHAR(32))
AS
SELECT TABLENAME FROM DOMAIN.TABLES where tablename = :TABLENAME;
IF $COUNT <> 0 THEN BEGIN
DROP TABLE :TABLENAME;
END;
//
CALL MYDROP('TESTTABLE')
but that one doesn't work either, 'cause as it seems, i only can drop TEMP.xxx tables
in a dbprocedure :(
i would be very happy if anyone can help.
thx!
Dominik
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
