sys.views - List of Existing Views in SQL Server


How To See Existing Views in SQL Server?



If you want to know how many views you have created in a database, you use the system view called sys.views to get a list of views defined in the current database. The tutorial exercise shows you how many views in database FyiCenterData:

USE FyiCenterData;

CREATE VIEW fyi_links_view AS
   SELECT * FROM fyi_links;

SELECT * FROM sys.views;
name            object_id   schema_id  type type_desc 
--------------- ----------- ---------- ---- ----------
fyi_links_view  1189579276  1          V    VIEW      
fyi_links_top   1205579333  1          V    VIEW      
(2 row(s) affected)


DROP VIEW - Deleting Existing Views in SQL Server

CREATE VIEW - Creating a View on an Existing Table in SQL Server

Understanding and Managing Views in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-11-05, 1975🔥, 0💬