Collections:
sys.views - List of Existing Views in SQL Server
How To See Existing Views in SQL Server?
✍: FYIcenter.com
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; GO CREATE VIEW fyi_links_view AS SELECT * FROM fyi_links; GO SELECT * FROM sys.views; GO 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
2016-11-05, 1992🔥, 0💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...