Check option
Select whether or not a check option should be defined for the view. A
check option on a view limits the values that can be inserted or updated through that view.
The possible choices are:
- Local - Creates the view with the local check option. This
specifies that every row that is inserted or updated through the view must
conform to the definition of that view. If the view is dependent on any other
views, only the definitions of those views that were created with the cascaded
check option or local check option will be checked.
- None - Creates the view without a check option. All inserts and updates are allowed unless there is a check
option on an underlying view.
- Cascaded - Creates the view with the cascaded check option. This specifies that every row that is inserted or updated
through the view must conform to the definition of that view. This means that after the insert or
update, the row can still be retrieved using the view. If the view is dependent on any other views, the
conditions of all the underlying views is checked at run time.