When Is a View Updatable?

A view behaves like a table because you can query data from it. However, you cannot always manipulate data via views. A view is updatable if the statement against the view can be translated into the corresponding statement against the underlying table.

How can you tell if a view is updatable?

If the view has not been defined using groups and aggregate functions. If the view does not have any distinct clause in its definition. If the view that is supposed to be updated is based on another view, the later should be updatable.

Which conditions must be satisfied for a view to be updatable?

A view is automatically updatable if it satisfies all of the following conditions: The view must have exactly one entry in its FROM list, which must be a table or another updatable view. The view definition must not contain WITH , DISTINCT , GROUP BY , HAVING , LIMIT , or OFFSET clauses at the top level.