View properties (DB2)

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.

Feedback