information_schema
.sequences
.*
relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
---|---|---|---|---|---|---|---|---|
sequences |
||||||||
cache |
unsupported | unsupported | TINYINT(4) NOT NULL :
| unsupported | unsupported | unsupported | ||
cache_value |
unsupported | unsupported | BIGINT(21) NULL :
| unsupported | unsupported | unsupported | ||
comment |
unsupported | unsupported | VARCHAR(64) NULL :
| unsupported | unsupported | unsupported | ||
cycle |
unsupported | unsupported | TINYINT(4) NOT NULL :
| unsupported | unsupported | unsupported | ||
cycle_option |
unsupported | unsupported | unsupported | CHARACTER_DATA :
YES_OR_NO :
YES_OR_NO NULL :
| unsupported | |||
data_type |
unsupported | unsupported | unsupported | CHARACTER_DATA :
CHARACTER_DATA NULL :
| unsupported | |||
increment |
unsupported | unsupported | BIGINT(21) NOT NULL :
| CARDINAL_NUMBER :
CHARACTER_DATA :
CHARACTER_DATA NULL :
| unsupported | |||
max_value |
unsupported | unsupported | BIGINT(21) NULL :
| unsupported | unsupported | unsupported | ||
maximum_value |
unsupported | unsupported | unsupported | CARDINAL_NUMBER :
CHARACTER_DATA :
CHARACTER_DATA NULL :
| unsupported | |||
min_value |
unsupported | unsupported | BIGINT(21) NULL :
| unsupported | unsupported | unsupported | ||
minimum_value |
unsupported | unsupported | unsupported | CARDINAL_NUMBER :
CHARACTER_DATA :
CHARACTER_DATA NULL :
| unsupported | |||
numeric_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER :
CARDINAL_NUMBER NULL :
| unsupported | |||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER :
CARDINAL_NUMBER NULL :
| unsupported | |||
numeric_scale |
unsupported | unsupported | unsupported | CARDINAL_NUMBER :
CARDINAL_NUMBER NULL :
| unsupported | |||
sequence_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | |||
sequence_name |
unsupported | unsupported | VARCHAR(64) NOT NULL :
| SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | |||
sequence_schema |
unsupported | unsupported | VARCHAR(64) NOT NULL :
| SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | |||
start |
unsupported | unsupported | BIGINT(21) NULL :
| unsupported | unsupported | unsupported | ||
start_value |
unsupported | unsupported | unsupported | CHARACTER_DATA :
CHARACTER_DATA NULL :
| unsupported | |||
table_catalog |
unsupported | unsupported | VARCHAR(512) NOT NULL :
| unsupported | unsupported | unsupported |