EM: Databases/SQL: Databases > Sequences

Description

The Databases, Sequences tab lists defined database sequences and their key values, including current value, increment, minimum, maximum, and cycle status.

Note: selecting a database from Databases name list, opens its configuration interface, and enabling access to Sequences.

Location

EM Navigator → Databases/SQL → Databases → Sequences

Toolbar

Button	Function
	Creates a new sequence.
	Deletes/Removes selected sequence.
	Refreshes the information.

Sequences Column

The Sequences column presents each defined sequence with its Sequence Name, Current value, Increment, Min., Max., and Cycle setting.

Sequences Column Settings

Settings	Description
Sequence Name	Name assigned to each sequence defined in the selected database.
Current	The current value presently stored for the sequence in the database.
Increment	The numeric amount added each time the sequence generates a value.
Min	Minimum value defined for the sequence in the database.
Max	Maximum value defined for the sequence in the database.
Cycle	Shows whether the sequence is set to cycle after reaching its maximum value.

Create a New Sequence

To create a new Sequence clicking the icon opens Create New Sequence dialog, where users define a sequence by entering its name, start value, increment, and maximum value. The dialog also explains that a sequence returns the next value at the specified increment when called from an SQL statement.

New Sequence Settings

Settings	Description
Sequence Name	The name used to identify the sequence within the selected database.
Start Value	The initial value assigned when the sequence is first created.
Increment	The numeric amount added each time the sequence advances forward.
Maximum Value	Sets the highest value the sequence can reach before stopping incrementing.