For more information about view syntax, see the
reference information
that is included with each database product. There might be differences
between
the IBM data
server syntax and the syntax for other vendors.
- General page
Property |
Description |
Name |
Specifies a name for the object. |
Label |
Specifies
a label that is displayed in visual diagrams. |
Schema |
Shows the relational
schema under which this object
was created. |
Check type |
Specifies a value for the WITH...CHECK OPTION
clause.
Available options are NONE, CASCADED, or LOCAL.- NONE
- The definition of the view is not used in the checking of any
insert or
update operations that use the view.
- CASCADED
- This view inherits the search conditions as constraints from any
updatable
view on which this view is dependent. Furthermore, every updatable
view that
is dependent on this view is also subject to these constraints. Thus,
the
search conditions of this view and each view on which this view is
dependent
are ANDed together to form a constraint that is applied for an insert
or update
of this view or of any view dependent on this view.
- LOCAL
- The search condition of this view is applied
as a constraint for an insert
or update of this view or of any view that is dependent on this view.
|
- Columns page
- Shows the columns that are included
in the view.
- SQL page
- Shows the
SQL source for the view.
- Documentation
page
- Specifies user-supplied information about the object.
- Annotation
page (in edit mode only)
- Add,
modify, or delete properties.