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 existBest of the Best ( like on CREATE INDEX )
CREATE TABLE TableName ... WITH DROP_EXISTINGYou known where found new MSQL Yukon TSQL language enhancement ?