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: 08/14/2024