Managing Sequences
A sequence generates a serial list of unique numbers for numeric columns of a database table. You can create, browse, drop, alter a sequence and view a report.
Database sequences are generally used to populate table primary keys.
- Creating a Sequence
Create a sequence using Object Browser. - Browsing a Sequence
Select a sequence from the Object Selection pane and view different reports about the sequence. - Reports for Sequences
Alternative views available when browsing a sequence in Object Browser. - Dropping a Sequence
Select a sequence from the Object Selection pane and click Drop. - Altering a Sequence
Select a sequence from the Object Selection pane and click Alter.
Parent topic: Managing Database Objects with Object Browser
Creating a Sequence
Create a sequence using Object Browser.
To create a sequence:
Parent topic: Managing Sequences
Browsing a Sequence
Select a sequence from the Object Selection pane and view different reports about the sequence.
To browse a sequence:
Parent topic: Managing Sequences
Reports for Sequences
Alternative views available when browsing a sequence in Object Browser.
Table 2-5 describes all available reports for sequences.
Table 2-5 Available Reports for Sequences
Parent topic: Managing Sequences
Dropping a Sequence
Select a sequence from the Object Selection pane and click Drop.
To drop a sequence:
Parent topic: Managing Sequences
Altering a Sequence
Select a sequence from the Object Selection pane and click Alter.
To alter a sequence
Parent topic: Managing Sequences