Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checking if a table exists
Message
 
To
29/02/2008 10:56:26
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Checking if a table exists
Miscellaneous
Thread ID:
01297733
Message ID:
01297738
Views:
12
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTable]') and OBJECTPROPERTY(id, N'IsTable') = 1)
drop table [dbo].[MyTable]
Woodie Westbrook
I came, I saw, I compiled.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform