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, 1361🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...