information_schema.element_types.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
element_types |
||||||||
array_type_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
| unsupported | unsupported | ||
character_maximum_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
character_octet_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
character_set_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
collection_type_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
data_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
datetime_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
domain_default |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
interval_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
numeric_scale |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | unsupported | ||
object_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
object_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
scope_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
scope_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
scope_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||