2.6 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
2.6.1 Creating a Sequence
Create a sequence using Object Browser.
To create a sequence:
Parent topic: Managing Sequences
2.6.2 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
2.6.3 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
2.6.4 Dropping a Sequence
Select a sequence from the Object Selection pane and click Drop.
To drop a sequence:
Parent topic: Managing Sequences
2.6.5 Altering a Sequence
Select a sequence from the Object Selection pane and click Alter.
To alter a sequence
Parent topic: Managing Sequences