Managing Sequences

A sequence generates a serial list of unique numbers for numeric columns of a database table. Database sequences are generally used to populate table primary keys.

Topics:

Creating a Sequence
Browsing a Sequence

Creating a Sequence

To create a sequence:

Navigate to Object Browser:
1. Click the SQL Workshop icon on the Workspace home page.
2. Click Object Browser.
  
  Object Browser appears.
Click Create.
From the list of object types, select Sequence.
Define the sequence, specify a sequence name, and click Next.

A confirmation page appears. To view the SQL used to create the sequence, click Show SQL.
Click Create.

Browsing a Sequence

To browse a sequence:

Navigate to Object Browser:
1. Click the SQL Workshop icon on the Workspace home page.
2. Click Object Browser.
  
  Object Browser appears.
From the Object list, select Sequences.
From the Object Selection pane, select a sequence.

The Object Details view appears.

Summary of Available Views

Click the tabs at the top of the page to view different reports about the sequence. Table 18-5 describes all available views.

Table 18-5 Available Views for Sequences

View	Description
Object Details	(Default) Displays details about the current sequence. Actions you can perform in this view include Alter and Drop.
Grant	Displays a list of grants associated with the sequence. Grant details include grantee, privilege, and grant options. Actions you can perform include Grant and Revoke.
Dependencies	Displays a list of objects that use (or depend) upon this sequence.
SQL	Displays the SQL necessary to re-create this sequence.