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.
Parent topic: Managing Database Objects with Object Browser
Create a sequence using Object Browser.
To create a sequence:
Parent topic: Managing Sequences
Select a sequence from the Object Selection pane and view different reports about the sequence.
To browse a sequence:
Parent topic: Managing 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
Select a sequence from the Object Selection pane and click Drop.
To drop a sequence:
Parent topic: Managing Sequences
Select a sequence from the Object Selection pane and click Alter.
To alter a sequence
Parent topic: Managing Sequences