Sequence properties (DB2)

Use the Properties view to modify the properties of a DB2® sequence.

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.
Data type Select a data type for the sequence value.
Type page
Property Description
Start value Type a value for the START WITH clause.
Increment Type a value for the INCREMENT BY clause.
Minimum Type a value for the MINVALUE clause.
Maximum Type a value for the MAXVALUE clause.
Cycle Select to specify the CYCLE option.
SQL page
Shows the SQL source for the view.
Documentation page
Type information about the object.
Annotation page
Add or delete properties and edit their values.

Feedback