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, 2888🔥, 0💬
Popular Posts:
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
What Are the Basic Features of a Trigger in SQL Server? Since a SQL Server trigger is a really an ev...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...