information_schema.routines.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
routines |
||||||||
as_locator |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| unsupported | ||
character_maximum_length |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| INT NULL:
| ||
character_octet_length |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| INT NULL:
| ||
character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
character_set_client |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
character_set_name |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
collation_connection |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
collation_name |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
created |
DATETIME NOT NULL:
5.7-8
| DATETIME NOT NULL:
NULL:
| unsupported | TIME_STAMP:
TIME_STAMP NULL:
| NULL:
| DATETIME NULL:
| ||
data_type |
VARCHAR NOT NULL:
5.7
LONGTEXT NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| NULL:
| NVARCHAR(128) NULL:
| ||
database_collation |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
datetime_precision |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
definer |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
dtd_identifier |
LONGTEXT NULL:
5.7-8
| LONGTEXT NULL:
10.2-10.7
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
external_language |
VARCHAR NOT NULL:
8
VARCHAR NULL:
5.7
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
external_name |
BINARY NULL:
5.7-8
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
interval_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
is_deterministic |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
is_implicitly_invocable |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
is_null_call |
unsupported | unsupported | unsupported | YES_OR_NO NULL:
CHARACTER_DATA:
| NULL:
| NVARCHAR(10) NULL:
| ||
is_udt_dependent |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO:
YES_OR_NO NULL:
| NULL:
| unsupported | ||
is_user_defined_cast |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
last_altered |
DATETIME NOT NULL:
5.7-8
| DATETIME NOT NULL:
NULL:
| unsupported | TIME_STAMP:
TIME_STAMP NULL:
| NULL:
| DATETIME NULL:
| ||
max_dynamic_result_sets |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| BIGINT NULL:
| ||
module_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
module_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
module_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
new_savepoint_level |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| unsupported | ||
numeric_precision |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
numeric_scale |
INT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
parameter_style |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
result_cast_as_locator |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| unsupported | ||
result_cast_char_max_length |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_char_octet_length |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_char_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_char_set_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_char_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_collation_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_collation_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_collation_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_datetime_precision |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_dtd_identifier |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_from_data_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| unsupported | ||
result_cast_interval_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_interval_type |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| unsupported | ||
result_cast_maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_numeric_precision |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_numeric_scale |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
result_cast_scope_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_scope_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_scope_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_type_udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_type_udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
result_cast_type_udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
routine_body |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
routine_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
routine_comment |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
routine_definition |
LONGTEXT NULL:
5.7-8
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(4000) NULL:
| ||
routine_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
routine_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
routine_type |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA NULL:
CHARACTER_DATA:
| NULL:
| NVARCHAR(20) NULL:
| ||
schema_level_routine |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
scope_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
scope_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
scope_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
security_type |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| unsupported | ||
specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
specific_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
sql_data_access |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(30) NULL:
| ||
sql_mode |
SET NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
sql_path |
BINARY NULL:
5.7-8
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
to_sql_specific_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
to_sql_specific_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
to_sql_specific_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
type_udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
SQL_IDENTIFIER:
| NULL:
| NVARCHAR(128) NULL:
| ||
type_udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
SQL_IDENTIFIER:
| NULL:
| NVARCHAR(128) NULL:
| ||
type_udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER NULL:
SQL_IDENTIFIER:
| NULL:
| NVARCHAR(128) NULL:
| ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||