IF
OBJECT_ID(‘Table_Name’,‘U’) is not null
TRUNCATE
TABLE Table_Name
ELSE
CREATE
TABLE Table_Name (
ID INT ,
Product_Name VARCHAR(100)
)
March 7, 2011 by Xart
IF
OBJECT_ID(‘Table_Name’,‘U’) is not null
TRUNCATE
TABLE Table_Name
ELSE
CREATE
TABLE Table_Name (
ID INT ,
Product_Name VARCHAR(100)
)
Posted in Database | Tagged Create Table If Not Exists Else Truncate | Leave a Comment
WPThemes.
Leave a comment