information_schema.user_defined_types.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
user_defined_types |
||||||||
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 | ||
data_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
datetime_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER 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 | ||
is_final |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO NULL:
| unsupported | unsupported | ||
is_instantiable |
unsupported | unsupported | unsupported | YES_OR_NO:
YES_OR_NO 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 | ||
ordering_category |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
ordering_form |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
ordering_routine_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
ordering_routine_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
ordering_routine_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
ref_dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
reference_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
source_dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_defined_type_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_defined_type_category |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
user_defined_type_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_defined_type_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||