Was this helpful?
Considerations
In general, no updates are supported on views derived from more than one base table.
You cannot update columns that are in the where clause of the view definition.
You can only update simple columns from the target_list of a view definition; you cannot update columns that are not simple columns (such as aggregates, derived columns, or constants).
You cannot update a row with a value that causes the row to be dropped from the view.
You can only define views based on tables for which you have retrieve permission.
When you destroy a table that is referenced by a view, the DBMS Server automatically destroys the view.
Last modified date: 01/30/2023