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, 2022🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...