• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. ALL_SEQUENCES

ALL_SEQUENCES

ALL_SEQUENCES stores all sequences accessible to the current user.

Table 1 ALL_SEQUENCES columns

Name

Type

Description

sequence_owner

name

Owner of the sequence

sequence_name

name

Name of the sequence

min_value

bigint

Minimum value of the sequence

max_value

bigint

Maximum value of the sequence

increment_by

bigint

Value by which the sequence is incremented

cycle_flag

character(1)

Whether the sequence is a cycle sequence. The value can be Y or N.

  • Y indicates that it is a cycle sequence.
  • N indicates that it is not a cycle sequence.