Check a view against sys.views : sys.views « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sys.views
IF EXISTS(SELECT *
    FROM sys.views
    WHERE name = 'vS' AND schema_id =
              SCHEMA_ID('HumanResources'))
    DROP VIEW HumanResources.vS
GO








27.21.sys.views
27.21.1.Reporting on Database Views by joining sys.columns and sys.views
27.21.2.Query sys.views
27.21.3.Check a view against sys.views