Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-2.x)/ System Catalogs and System Views/ System Views/ DB_SEQUENCES
Updated on 2025-02-27 GMT+08:00
View PDF
Share

DB_SEQUENCES

DB_SEQUENCES displays all sequences accessible to the current user. This view exists in both the PG_CATALOG and SYS schemas.

Table 1 DB_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 the sequence.

max_value

int16

Maximum value of the sequence.

increment_by

int16

Value by which a sequence is incremented.

cycle_flag

character(1)
Specifies whether the 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