Collections:
Deleting a Table That Is Used by a View in SQL Server
What Happens If You Delete a Table That Is Used by a View in SQL Server?
✍: FYIcenter.com
Assuming that you have a table which is used by a view, and you try to delete that table. SQL Server will let you delete the table without any trouble.
But that view will become invalid. The tutorial exercise below shows you what happens to the view, when the underlying table is deleted:
USE FyiCenterData; GO SELECT * INTO fyi_links_copy FROM fyi_links WHERE counts > 0; GO CREATE VIEW fyi_links_view AS SELECT * FROM fyi_links_copy; GO SELECT COUNT(*) FROM fyi_links_view; GO 50015 DROP TABLE fyi_links_copy; GO SELECT COUNT(*) FROM fyi_links_view; GO Msg 208, Level 16, State 1, Line 1 Invalid object name 'fyi_links_copy'. Msg 4413, Level 16, State 1, Line 1 Could not use view or function 'fyi_links_view' because of binding errors.
⇒ Using ORDER BY to Define a View in SQL Server
⇐ Creating a View with Data from Another View in SQL Server
2016-11-04, 1879🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...