Collections:
DROP VIEW - Deleting Existing Views in SQL Server
How To Drop Existing Views from a Database in SQL Server?
✍: FYIcenter.com
If you don't need a specific view any more, you can use the DROP VIEW statement to delete it from the database. The following tutorial exercise shows you how to delete the view, fyi_links_view:
USE FyiCenterData; 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 fyi_links_view; GO SELECT * FROM sys.views; GO name object_id schema_id type type_desc --------------- ----------- ---------- ---- ---------- fyi_links_top 1205579333 1 V VIEW (1 row(s) affected)
⇒ "sys.columns" - Getting a List of Columns in a View in SQL Server
⇐ sys.views - List of Existing Views in SQL Server
2016-11-05, 1305🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...