Sequences

Use this page to view information about the sequences in a database.

A sequence is a database object that generates a sequence of whole numbers within a defined range. The page displays the following information about the sequences:

• Sequence
• Owner
• Cycle: Indicates whether sequence values continue to be generated after the sequence reaches the maximum (ascending) or minimum (descending) value. A check mark indicates that sequence values continue to be generated. After an ascending sequence reaches the maximum value, it generates the minimum value for the next sequence value. After a descending sequence reaches the minimum value, it generates the maximum value for the next sequence value.
• Increment: The increment between successive values.
• Cache: The number of sequence values that are preallocated in the sequence cache.
• Start: The first number of the sequence.
• Min: The minimum value.
• Max: The maximum value.
• Restart: The new first number of the sequence.
• User
• Privileges:
  • S: Select
  • U: Update
  • I: Insert
  • D: Delete
  • X: Index
  • A: Alter
  • R: References
  • N: Under
• Grantor