Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Reference » Views » System views


SYSSEQUENCE system view

The SYSSEQUENCE system view contains one row for each user-defined sequence. The underlying system table for this view is ISYSSEQUENCE.

Column name Data type Description
object_id UNSIGNED BIGINT The unique number assigned to each sequence.
owner UNSIGNED INT The owner of the sequence.
min_value BIGINT The minimum value allowed for the sequence.
max_value BIGINT The maximum value allowed for the sequence.
increment_by BIGINT The increment value for the sequence.
start_with BIGINT The starting value for the sequence.
cache UNSIGNED INT The number of sequence values to preallocate in memory for faster access. A value of 0 indicates that values are not to be preallocated
cycle TINYINT Whether values should continue to be generated after the maximum or minimum value is reached.
resume_at BIGINT The RESTART WITH value specified by the ALTER SEQUENCE statement. The value is NULL if no ALTER RESTART WITH statement has been executed.
sequence_name CHAR(128) The name of the sequence.
 Constraints on underlying system table