Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Drop object ?
Message
From
31/07/2003 11:48:14
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00815406
Message ID:
00815439
Views:
8
Hi Sergey,

for simplified recreation of one sql object
( i have developer a VFP_MSQL integrated framework support builder ).

Before CREATE ... i need:
IF (SELECT OBJECT_ID('objectName')) IS NOT NULL 
  DROP <OBJECTTYPECLAUSE> objectName

CREATE <OBJECTTYPECLAUSE>
Better it would be :
  DROP objectName -- SQL ignore command if objectName not exist
Best of the Best ( like on CREATE INDEX )
CREATE TABLE TableName ... WITH DROP_EXISTING
You known where found new MSQL Yukon TSQL language enhancement ?

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform