Purpose
information_schema.ROUTINES displays information about stored procedures.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SPECIFIC_NAME | varchar(64) | NO | The name of the stored procedure. |
| ROUTINE_CATALOG | varchar(3) | NO | The name of the catalog to which the stored procedure belongs. At present, this field is not used, and the current value is def. |
| ROUTINE_SCHEMA | varchar(128) | NO | The name of the schema to which the stored procedure belongs. |
| ROUTINE_NAME | varchar(128) | NO | The name of the stored procedure. The value is the same as that of SPECIFIC_NAME. |
| ROUTINE_TYPE | varchar(10) | NO | The type of the routine. Valid values: |
| DATA_TYPE | varchar(0) | NO | The data type of the return value of the routine if the routine is a stored function. If the routine is a stored procedure, this field is empty. At present, this field is not used. |
| CHARACTER_MAXIMUM_LENGTH | null | NO | The maximum character length for string return values of the routine if the routine is a stored function. If the routine is a stored procedure, the value of this field is NULL. At present, this field is not used. |
| CHARACTER_OCTET_LENGTH | null | NO | The maximum byte length for string return values of the routine if the routine is a stored function. If the routine is a stored procedure, the value of this field is NULL. At present, this field is not used. |
| NUMERIC_PRECISION | null | NO | The numeric precision for numeric return values of the routine if the routine is a stored function. If the routine is a stored procedure, the value of this field is NULL. At present, this field is not used. |
| NUMERIC_SCALE | null | NO | The numeric scale for numeric return values of the routine if the routine is a stored function. If the routine is a stored procedure, the value of this field is NULL. At present, this field is not used. |
| DATETIME_PRECISION | null | NO | The fractional seconds precision for temporal return values of the routine if the routine is a stored function. If the routine is a stored procedure, the value of this field is NULL. At present, this field is not used. |
| CHARACTER_SET_NAME | null | NO | The character set name for string return values of the routine if the routine is a stored function. If the routine is a stored procedure, the value of this field is NULL. At present, this field is not used. |
| COLLATION_NAME | null | NO | The collation name for string return values of the routine if the routine is a stored function. If the routine is a stored procedure, the value of this field is NULL. At present, this field is not used. |
| DTD_IDENTIFIER | null | NO | Reserved for future use. The data type of the return value of the routine if the routine is a stored function. If the routine is a stored procedure, this field is empty. The value of DATA_TYPE contains only the type name, without other information. The value of DTD_IDENTIFIER contains the type name and possibly other information such as the precision or length. |
| ROUTINE_BODY | varchar(3) | NO | The language used for the routine definition. The value of this field is fixed to SQL. |
| ROUTINE_DEFINITION | varchar(1048576) | NO | The text information of the stored procedure definition. |
| EXTERNAL_NAME | null | NO | The value of this field is fixed to NULL. |
| EXTERNAL_LANGUAGE | null | NO | The language of the stored procedure. At present, this field is not used. |
| PARAMETER_STYLE | varchar(3) | NO | The value of this field is fixed to SQL. |
| IS_DETERMINISTIC | varchar(4) | NO | Indicates whether the stored procedure is defined with the DETERMINISTIC characteristic. Valid values: Yes and No. At present, this field is not used. |
| SQL_DATA_ACCESS | varchar(32) | NO | Reserved for future use. The data access characteristic for the stored procedure. |
| SQL_PATH | null | NO | The value of this field is fixed to NULL. |
| SECURITY_TYPE | varchar(10) | NO | The SQL mode. Valid values: DEFINER and INVOKER. At present, this field is not used. |
| CREATED | timestamp(6) | NO | The date and time when the stored procedure was created. |
| LAST_ALTERED | timestamp(6) | NO | The date and time when the stored procedure was last modified. If the routine has not been modified since its creation, the value of this field is the same as the value of CREATED. |
| SQL_MODE | varchar(32) | NO | The SQL mode in effect when the routine was created or modified and under which the routine executes. |
| ROUTINE_COMMENT | varchar(1048576) | NO | The text of the comment. |
| DEFINER | varchar(77) | NO | The account named in the DEFINER sub-clause (often the user who created the routine). |
| CHARACTER_SET_CLIENT | varchar(128) | NO | The session value of the system variable CHARACTER_SET_CLIENT when the stored procedure was created or modified. |
| COLLATION_CONNECTION | varchar(128) | NO | The session value of the system variable COLLATION_CONNECTION when the stored procedure was created or modified. |
| DATABASE_COLLATION | varchar(128) | NO | The session value of the system variable DATABASE_COLLATION when the stored procedure was created or modified. |