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, 1280🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...