Help Center> GaussDB> Distributed_2.x> System Catalogs and System Views> System Views> MY_SEQUENCES
Updated on 2023-10-23 GMT+08:00
View PDF

MY_SEQUENCES

MY_SEQUENCES displays information about sequences in the current schema. This view exists in the PG_CATALOG and SYS schemas.

Table 1 MY_SEQUENCES columns

Name

Type

Description

sequence_owner

name

Owner of a sequence

sequence_name

name

Name of a sequence

min_value

int16

Minimum value of a sequence

max_value

int16

Maximum value of a sequence

increment_by

int16

Value by which a sequence is incremented

cycle_flag

character(1)
Whether a sequence is a cycle sequence. The value can be Y or N.
  • Y: It is a cycle sequence.
  • N: It is not a cycle sequence.

last_number

int16

Value of the previous sequence

cache_size

int16

Size of the sequence disk cache
Parent topic: System Views