Use the Properties view to modify the properties of a DB2® view.
For more information about DB2 syntax, see the reference information
that is included with each product. There may be differences between DB2 syntax and
the syntax for other vendors.
- General page
-
Property |
Description |
Name |
Type a name. |
Label |
Type a label. This label is displayed in visual diagrams. |
Schema |
Shows the relational schema under which this object
was created. |
Check type |
Select a value for the WITH...CHECK OPTION clause. You
can select NONE, CASCADED, or LOCAL. |
- Columns page
- Shows the columns that are included in the view. The properties on this
page cannot be edited.
- SQL page
- Shows the SQL source for the view.
- Relationships page
- Shows objects that are related to the object and information about the
relationship. These fields cannot be edited. Use a data diagram to add relationships
between objects.
- Documentation page
- Type information about the object.
- Annotation page
- Add or delete properties and edit their values.