Mega Code Archive

 

Categories / MSSQL / View

 

Drop a view if it exists

3> 4> IF EXISTS(SELECT * 5>     FROM sys.views 6>     WHERE name = 'StudentGrades' AND 7>     schema_id = SCHEMA_ID('dbo')) 8>     DROP VIEW dbo.StudentGrades 9> GO 1>