information_schema.columns.*

show items implemented by
relation column mysqlmariadbtidbpostgrescockroachdbmssql
columns  
character_maximum_length BIGINT NULL:
5.7-8
NULL: BIGINT(21) NULL: CARDINAL_NUMBER: CARDINAL_NUMBER NULL: INT NULL:
character_octet_length BIGINT NULL:
5.7-8
NULL: BIGINT(21) NULL: CARDINAL_NUMBER: CARDINAL_NUMBER NULL: INT NULL:
character_set_catalog unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
character_set_name VARCHAR NULL:
5.7-8
NULL: VARCHAR(32) NULL: SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
character_set_schema unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
collation_catalog unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
collation_name VARCHAR NULL:
5.7-8
NULL: VARCHAR(32) NULL: SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
collation_schema unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
column_comment TEXT NOT NULL:
5.7-8
VARCHAR NOT NULL: NULL: VARCHAR(1024) NULL: unsupported unsupported
column_default LONGTEXT NULL:
5.7-8
NULL: TEXT NULL: CHARACTER_DATA: CHARACTER_DATA NULL: NVARCHAR(4000) NULL:
column_key ENUM NOT NULL:
5.7-8
VARCHAR NOT NULL: NULL: VARCHAR(3) NULL: unsupported unsupported unsupported
column_name VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
VARCHAR NOT NULL: NULL: VARCHAR(64) NULL: SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
column_type LONGTEXT NOT NULL:
5.7-8
LONGTEXT NOT NULL: NULL: TEXT NULL: unsupported unsupported unsupported
crdb_sql_type unsupported unsupported unsupported unsupported unsupported
data_type VARCHAR NOT NULL:
5.7
LONGTEXT NULL:
8
VARCHAR NOT NULL: NULL: VARCHAR(64) NULL: CHARACTER_DATA: CHARACTER_DATA NULL: NVARCHAR(128) NULL:
datetime_precision BIGINT NULL:
5.7-8
NULL: BIGINT(21) NULL: CARDINAL_NUMBER: CARDINAL_NUMBER NULL: SMALLINT NULL:
domain_catalog unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
domain_name unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
domain_schema unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
dtd_identifier unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: unsupported
extra VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
VARCHAR NOT NULL: NULL: VARCHAR(30) NULL: unsupported unsupported unsupported
generation_expression LONGTEXT NOT NULL:
5.7-8
NULL: TEXT NOT NULL: CHARACTER_DATA NULL: CHARACTER_DATA: unsupported
identity_cycle unsupported unsupported unsupported CHARACTER_DATA: YES_OR_NO NULL: unsupported
identity_generation unsupported unsupported unsupported CHARACTER_DATA: CHARACTER_DATA NULL: unsupported
identity_increment unsupported unsupported unsupported CHARACTER_DATA: CHARACTER_DATA NULL: unsupported
identity_maximum unsupported unsupported unsupported CHARACTER_DATA: CHARACTER_DATA NULL: unsupported
identity_minimum unsupported unsupported unsupported CHARACTER_DATA: CHARACTER_DATA NULL: unsupported
identity_start unsupported unsupported unsupported CHARACTER_DATA: CHARACTER_DATA NULL: unsupported
interval_precision unsupported unsupported unsupported CHARACTER_DATA: CARDINAL_NUMBER: CARDINAL_NUMBER NULL: unsupported
interval_type unsupported unsupported unsupported CHARACTER_DATA: CHARACTER_DATA NULL: unsupported
is_generated unsupported VARCHAR NOT NULL: NULL: unsupported CHARACTER_DATA NULL: CHARACTER_DATA: unsupported
is_hidden unsupported unsupported unsupported unsupported unsupported
is_identity unsupported unsupported unsupported CHARACTER_DATA: YES_OR_NO NULL: unsupported
is_nullable VARCHAR NOT NULL:
5.7-8
VARCHAR NOT NULL: NULL: VARCHAR(3) NULL: CHARACTER_DATA: YES_OR_NO NULL: VARCHAR(3) NULL:
is_self_referencing unsupported unsupported unsupported CHARACTER_DATA: YES_OR_NO NULL: unsupported
is_updatable unsupported unsupported unsupported CHARACTER_DATA: YES_OR_NO NULL: unsupported
maximum_cardinality unsupported unsupported unsupported CARDINAL_NUMBER: CARDINAL_NUMBER NULL: unsupported
numeric_precision BIGINT NULL:
5.7-8
NULL: BIGINT(21) NULL: CARDINAL_NUMBER: CARDINAL_NUMBER NULL: TINYINT NULL:
numeric_precision_radix unsupported unsupported unsupported CARDINAL_NUMBER: CARDINAL_NUMBER NULL: SMALLINT NULL:
numeric_scale BIGINT NULL:
5.7-8
NULL: BIGINT(21) NULL: CARDINAL_NUMBER: CARDINAL_NUMBER NULL: INT NULL:
ordinal_position BIGINT NOT NULL:
5.7-8
BIGINT NOT NULL: NULL: BIGINT(64) NULL: CARDINAL_NUMBER: CARDINAL_NUMBER NULL: INT NULL:
privileges VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
VARCHAR NOT NULL: NULL: VARCHAR(80) NULL: unsupported unsupported unsupported
scope_catalog unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: unsupported
scope_name unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: unsupported
scope_schema unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: unsupported
srs_id INT NULL:
8
unsupported unsupported unsupported unsupported unsupported
table_catalog VARCHAR NOT NULL:
5.7-8
VARCHAR NOT NULL: NULL: VARCHAR(512) NULL: SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
table_name VARCHAR NOT NULL:
5.7-8
VARCHAR NOT NULL: NULL: VARCHAR(64) NULL: SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
table_schema VARCHAR NOT NULL:
5.7-8
VARCHAR NOT NULL: NULL: VARCHAR(64) NULL: SQL_IDENTIFIER: SQL_IDENTIFIER NULL: NVARCHAR(128) NULL:
udt_catalog unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: unsupported
udt_name unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: unsupported
udt_schema unsupported unsupported unsupported SQL_IDENTIFIER: SQL_IDENTIFIER NULL: unsupported