Drop a view if it exists : Drop View « View « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. View
  3. Drop 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>








Related examples in the same category

1.Creating a View Using SQL Script and then drop it