information_schema.parameters.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
parameters |
||||||||
as_locator |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
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_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_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:
| ||
data_type |
VARCHAR NOT NULL:
5.7
LONGTEXT NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
datetime_precision |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
dtd_identifier |
LONGTEXT NOT NULL:
5.7-8
| LONGTEXT NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
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_result |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
maximum_cardinality |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| unsupported | ||
numeric_precision |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| TINYINT NULL:
| ||
numeric_precision_radix |
unsupported | unsupported | unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| SMALLINT NULL:
| ||
numeric_scale |
BIGINT NULL:
5.7-8
| NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| TINYINT NULL:
| ||
ordinal_position |
BIGINT NOT NULL:
5.7-8
| INT NOT NULL:
NULL:
| unsupported | CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| NULL:
| INT NULL:
| ||
parameter_default |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| unsupported | ||
parameter_mode |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| NULL:
| NVARCHAR(10) NULL:
| ||
parameter_name |
VARCHAR NULL:
5.7-8
| NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
routine_type |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
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:
| NULL:
| NVARCHAR(128) NULL:
| ||
specific_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| 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 |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| NVARCHAR(128) NULL:
| ||
udt_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
udt_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
udt_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NULL:
| unsupported | ||
user_defined_type_catalog |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
user_defined_type_name |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||
user_defined_type_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | NVARCHAR(128) NULL:
| ||