Updating views in sql
For Oracle views you can Google for "updatable join view" for some examples of when you can and cannot update a view.
When a view is created in SQL Server, metadata for the referenced table columns (column name and ordinal position) is persisted in the database.
-If the view does not have any distinct clause in its definition.A view can contain all rows of a table or select rows from a table.A view can be created from one or many tables which depends on the written SQL query to create a view.Edit: This is MS SQL The rules for updatable join views are as follows: General Rule Any INSERT, UPDATE, or DELETE operation on a join view can modify only one underlying base table at a time.
UPDATE Rule All updatable columns of a join view must map to columns of a key-preserved table.
For information about generated columns, see Section 18.104.22.168, “CREATE TABLE and Generated Columns”.