SQL Server/T-SQL Tutorial/System Tables Views/sys.views

Check a view against sys.views

   <source lang="sql">

IF EXISTS(SELECT *

   FROM sys.views
   WHERE name = "vS" AND schema_id =
             SCHEMA_ID("HumanResources"))
   DROP VIEW HumanResources.vS

GO</source>

Query sys.views

   <source lang="sql">

4> SELECT top 10 name, schema_id 5> FROM sys.views 6> GO name schema_id

---

-----------

titleview 1 vwProductList 1 vV 1 (3 rows affected)</source>

Reporting on Database Views by joining sys.columns and sys.views

   <source lang="sql">

4> 5> 6> SELECT v.name ViewName, 7> c.name ColumnName 8> FROM sys.columns c 9> INNER JOIN sys.views v ON 10> c.object_id = v.object_id 11> ORDER BY v.name, 12> c.name 13> GO ViewName

        ColumnName

---

---

---------------------------------------------------------------------------------------------------------------

---

(0 rows affected) 1></source>