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