Friday 23 December 2016

drop table if exist


IF (EXISTS (SELECT *
                 FROM INFORMATION_SCHEMA.TABLES
                 WHERE TABLE_SCHEMA = 'dbo'
                 AND  TABLE_NAME = empTable))
Begin
 DROP TABLE empTable
End

No comments:

Post a Comment