Properties for IBM® data
server view objects
For more information about specific syntax, see the reference
information that is included with each database product. Syntax definitions
for some database vendors or versions might differ from the following
descriptions.
- 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.