Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

Check existance of a view by using OBJECT_ID

6> IF OBJECT_ID('dbo.VCustsWithOrders') IS NOT NULL 7>   DROP VIEW dbo.VCustsWithOrders; 8> GO