Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Object
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Re: Object
Miscellaneous
Thread ID:
00975053
Message ID:
00975055
Views:
15
if exists (select * from dbo.sysobjects 
		where id = object_id(N'dbo.mytable') 
		and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	drop table dbo.mytable
> How can I check if a table exist and if id does I want to drop that table?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform