Collections:
Deleting Data from a View in SQL Server
Can You Delete Data from a View in SQL Server?
✍: FYIcenter.com
Can you delete data in a view? The answer is no.
But if the question is "Can you delete data from the underlying table through view?" The answer is then yes. SQL Server will allow you to delete data from the underlying table through a view. The tutorial exercise below is a good example:
DELETE FROM fyi_links_top WHERE id = 100001; GO SELECT * FROM fyi_links_top; GO 36470 999966 dgqnvmy pyjqd toqcoupuxortasdtzvcae jonfb 12292 999953 qebmw v qqmywe q kza wskxqns jnb 6192 999943 p o qisvrakk hk od SELECT TOP 1 * FROM fyi_links ORDER BY counts DESC; GO id url ... ------ ------------------------------------------- ... 36470 dgqnvmy pyjqd toqcoupuxortasdtzvcae jonfb ... 999966 1977-09-08 04:28:01.523
⇒ Assigning New Column Names in a View in SQL Server
⇐ Updating Data in a View in SQL Server
2016-11-03, 3045🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...