3.6 Managing Sequences
A sequence generates a serial list of unique numbers for numeric columns of a database table. Use Object Browser to create, view, or drop a sequence.
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 Tree and access tabs in the Object Detail View. - Dropping a Sequence
Select a sequence from the Object Tree pane and click Drop on the Object Details tab.
Parent topic: Managing Database Objects with Object Browser
3.6.1 Creating a Sequence
Create a sequence using Object Browser.
To create a sequence:
Parent topic: Managing Sequences
3.6.2 Browsing a Sequence
Select a sequence from the Object Tree and access tabs in the Object Detail View.
To browse a sequence:
- In Object Browser, Object Tree, expand Sequences and select a sequence.
- The Object Detail View appears and displays four tabs:
- Object Details - Displays details
about the selected type. Available actions include:
- Alter
- Drop
- Refresh
- Grants - Displays a list of grants
associated with the sequence. Available actions include:
- Grant
- Revoke
- Refresh
- Dependencies - Displays a list of objects that use (or depend) upon this sequence. Available actions include: Refresh.
- DDL - Displays the DDL necessary to re-create this sequence. Available actions include:
- Download.
- Refresh
- Object Details - Displays details
about the selected type. Available actions include:
Parent topic: Managing Sequences
3.6.3 Dropping a Sequence
Select a sequence from the Object Tree pane and click Drop on the Object Details tab.
To drop a sequence:
Parent topic: Managing Sequences