View MSSQL

  1. Home
  2. MSSQL
  3. View
  4. 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>