Re: checking if a table exists?

[Mark Drew]

> Is it possible and if so how to check if a table exists?

Depending on the database but in MSSQL is:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[que_log]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)
drop table [dbo].[que_log]
GO

AND in MySQL it is;
DROP TABLE IF EXISTS que_log;

Hope that helps

--
Mark Drew
http://cybersonic.blogspot.com
mailto:[EMAIL PROTECTED]

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---