Column Name | Data Type | Description |
seq_name | char(256) | The name of the sequence |
seq_owner | char(32) | The owner of the sequence |
create_date | ingresdate | The date on which the sequence was created |
modify_date | ingresdate | The date on which the sequence was last altered |
data_type | varchar(7) | The data type of the sequence integer bigint decimal |
seq_length | smallint | The size in bytes of the sequence value |
seq_precision | integer | The precision in decimal digits of the sequence value |
start_value | decimal(31) | The start value (or restart value) of the sequence |
increment_value | decimal(31) | The increment value of the sequence |
next_value | decimal(31) | The next sequence value to be assigned |
min_value | decimal(31) | The minimum value of the sequence |
max_value | decimal(31) | The maximum value of the sequence |
cache_size | integer | The number of cached sequence values |
start_flag | char(1) | Y if start value was defined N if start value was not defined |
incr_flag | char(1) | Y if increment value was defined N if increment value was not defined |
min_flag | char(1) | Y if minimum value was defined N if minimum value was not defined |
max_flag | char(1) | Y if maximum value was defined N if maximum value was not defined |
restart_flag | char(1) | Y if restart value was defined N if restart value was not defined |
cache_flag | char(1) | Y if cache value was defined N if cache value was not defined |
cycle_flag | char(1) | Y if cycle was defined N if cycle was not defined |
order_flag | char(1) | Y if order was defined N if order was not defined |
unordered_flag | char(1) | Y if unordered sequence N if not unordered sequence |
seql_flag | char(1) | Y if sequential (not unordered) sequence N if not sequential sequence |
ident_flag | char(1) | Y if sequence associated with an identity column N if not |