DB_SEQUENCES

DB_SEQUENCES displays all sequences accessible to the current user. This view exists in both 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 the sequence.
min_value	int16	Minimum value of the sequence.
max_value	int16	Maximum value of the sequence.
last_number	int16	Value of the previous sequence.
cache_size	int16	Size of the sequence disk cache.
increment_by	int16	Value by which the sequence is incremented.
cycle_flag	character(1)	Specifies whether the sequence is a cyclic sequence. The value can be Y or N. Y: It is a cyclic sequence. N: It is not a cyclic sequence.

Parent topic:System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.