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.|
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|