ADM_SEQUENCES

ADM_SEQUENCES displays information about all sequences in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** ADM_SEQUENCES columns
Name	Type	Description
sequence_owner	character varying(64)	Owner of a sequence
sequence_name	character varying(64)	Name of a sequence
min_value	int16	Minimum value of a sequence
max_value	int16	Maximum value of a sequence
increment_by	int16	Increment of a sequence
last_number	int16	Value of the previous sequence
cache_size	int16	Size of the sequence disk cache
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.