Purpose
information_schema.PARAMETERS displays information about parameters and returns values for stored procedures.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SPECIFIC_CATALOG | VARCHAR(4096) | NO | The name of the catalog to which the table containing the column belongs. The value of this field is fixed to def. |
| SPECIFIC_SCHEMA | VARCHAR(128) | NO | The name of the database. |
| SPECIFIC_NAME | VARCHAR(128) | NO | The name of the stored procedure containing the parameter. |
| ORDINAL_POSITION | BIGINT(20) | NO | The position of the parameter (the value is 0 for the return value of a function). |
| PARAMETER_MODE | VARCHAR(128) | YES | The type of the parameter. Valid values: |
| PARAMETER_NAME | VARCHAR(262144) | YES | The name of the parameter. |
| DATA_TYPE | VARCHAR(128) | NO | The data type of the parameter. |
| CHARACTER_MAXIMUM_LENGTH | BIGINT(20) UNSIGNED | YES | The maximum length in characters for string parameters. |
| CHARACTER_OCTET_LENGTH | BIGINT(20) UNSIGNED | YES | The maximum byte length for string parameters. |
| NUMERIC_PRECISION | BIGINT(20) UNSIGNED | YES | The numeric precision for numeric parameters. |
| NUMERIC_SCALE | BIGINT(20) UNSIGNED | YES | The numeric scale for numeric parameters. |
| DATETIME_PRECISION | BIGINT(20) UNSIGNED | YES | The datetime precision for temporal parameters. |
| CHARACTER_SET_NAME | VARCHAR(128) | YES | The character set name for string parameters. |
| COLLATION_NAME | VARCHAR(128) | YES | The collation for string parameters. |
| DTD_IDENTIFIER | VARCHAR(128) | NO | The detailed information about the data type recorded in characters. |
| ROUTINE_TYPE | VARCHAR(9) | NO | The type of the stored procedure (procedure or function). |