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 |