INSERT, UPDATE and DELETE statements may be used on views.
The operation is then performed on the base table upon which the view is defined. However, certain views may not be updated (for example a view containing DISTINCT values, where a single row in the view may represent several rows in the base table).
A view is not updatable if any of the following conditions are true:
- the keyword DISTINCT is used in the view definition
- the select list contains components other than column specifications, or contains more than one specification of the same column
- the FROM clause specifies more than one table reference or refers to a non-updatable view
- the GROUP BY clause is used in the view definition
- the HAVING clause is used in the view definition
Note: A view will always be updatable if an INSTEAD OF trigger exists on the view, regardless of the conditions previously mentioned. If all the INSTEAD OF triggers on the view are dropped, the view will revert to not updatable if one or more of these conditions are true.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40