PPT Slide
The restrictions on inserting or
updating data to an underlying table
through a simple view are listed here:
- The user may not insert, delete, or
update data on the table underlying
the simple view if the view itself is not
able to select that data for the user if
the with check option is used.
- The user may not insert, delete, or
update data on the table underlying
the simple view if the select statement
creating the view contains group by or
order by, or a single-row operation.