Answer: A VIEW in SQL is created by joining one or more tables. When you update record(s) in a view, it updates the records in the underlying tables that make up the SQL View. So, yes, you can update the data in a SQL VIEW providing you have the proper privileges to the underlying SQL tables.
Can views be updated in SQL Server?
View is like a virtual table which enable us to get information of multiple tables. yes we can insert,update and delete view in sql server.
How do I update an existing SQL view?
Using SQL Server Management Studio
- In Object Explorer, click the plus sign next to the database where your view is located and then click the plus sign next to the Views folder.
- Right-click on the view you wish to modify and select Design.
