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, 1292🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...