Open topic with navigation
CREATE VIEW statement, the
column_list for an updatable view must follow these rules:
column_listcan contain only single field references. In other words, all columns in the
SELECTlist must also be columns in the table referenced in the
FROMclause. A view with one or more derived columns is not updatable. A derived column is a column that is generated based on an expression, for example:
column_listcannot be a subquery.
column_listcannot contain an aggregate function, for example:
COUNT(see SQL Aggregate Functions).
column_listcannot contain the
DISTINCTkeyword because doing so would make it possible to not update any row in the underlying table as well as to not update all rows of the underlying table.