Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Check a view against sys views

IF EXISTS( SELECT *     FROM sys.views     WHERE name = 'vS' AND schema_id =               SCHEMA_ID('HumanResources'))     DROP VIEW HumanResources.vS GO