Manage sequences

In the sequence list, right-click a target object to perform management operations, or double-click a sequence name to open the sequence management page.

Management operations

By default, sequence objects in the list are sorted in ascending order by the first character of their names.

Right-click an object in the sequence list. A shortcut menu appears with options to quickly manage the object. The following table describes these operations.

Operation	Description
Create Sequence	Opens the Create Sequence page. Follow the steps to create a new sequence object.
View Sequence	Opens the sequence management page to view all basic information, properties, and DDL information of the current sequence.
Modify	Opens the Properties section of the sequence management page to modify the information of the current sequence.
Delete	Deletes the current sequence.
Export	Exports data from a single table. For more information, see Import and Export.
Download	Downloads the SQL file of the sequence object.
Refresh	Refreshes the list to show the latest information after you perform management operations.

Sequence management page

The sequence management page displays the following information:

• Basic Information: Displays information such as Sequence Name and Username. Click the edit icon in the toolbar to edit the basic information. Click the refresh icon to refresh the basic information.

• Properties: Displays properties such as Next Cached Value, Increment By, Minimum Value, Maximum Value, Cache Settings, Order, and Cycle. The Next Cached Value property displays the value of last_number from the sequence view. This value is read-only.

• DDL (Data Definition Language): Displays the script that defines the sequence.

  Click the download icon in the toolbar to download the DDL script as a local file. Click the format icon to format the statement for better readability. Click the refresh icon to refresh the DDL.