/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
IF EXISTS ( SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'MyTable' AND TABLE_SCHEMA = 'dbo' ) BEGIN DROP TABLE dbo.MyTable PRINT 'Dropped dbo.MyTable' END