routines

The routines view provides information about stored routines (stored procedures and stored functions). This view is read-only. All users have the read permission on this view.

**Table 1** information_schema.routines columns
Name	Type	Description
SPECIFIC_NAME	varchar(64)	Name of the routine.
ROUTINE_CATALOG	varchar(512)	Name of the catalog to which the routine belongs. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
ROUTINE_SCHEMA	varchar(64)	Name of the schema to which the routine belongs. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
ROUTINE_NAME	varchar(64)	Name of the routine.
ROUTINE_TYPE	varchar(9)	procedure: stored procedure function: stored function
DATA_TYPE	varchar(64)	Return value data type if the routine is a stored function. If the routine is a stored procedure, it is void.
CHARACTER_MAXIMUM_LENGTH	integer	Maximum string length for stored function string return values, in characters. If the routine is a stored procedure, the value is null.
CHARACTER_OCTET_LENGTH	integer	Maximum string length for stored function string return values, in bytes. If the routine is a stored procedure, the value is null.
NUMERIC_PRECISION	bigint unsigned	Numeric precision for stored function numeric return values. If the routine is a stored procedure, the value is null.
NUMERIC_SCALE	integer	Numeric scale for stored function numeric return values. If the routine is a stored procedure, the value is null.
DATETIME_PRECISION	bigint unsigned	Fractional seconds precision for stored function temporal return values. If the routine is a stored procedure, the value is null.
CHARACTER_SET_NAME	varchar(64)	Character set name for stored function character string return values. If the routine is a stored procedure, the value is null.
COLLATION_NAME	varchar(64)	Collation name for stored function character string return values. If the routine is a stored procedure, the value is null.
DTD_IDENTIFIER	longtext	Return value data type if the routine is a stored function. If the routine is a stored procedure, it is void.
ROUTINE_BODY	varchar(8	Language used for the routine definition. It is always SQL.
ROUTINE_DEFINITION	longtext	Text of the SQL statement executed by the routine.
EXTERNAL_NAME	varchar(64)	It is always null.
EXTERNAL_LANGUAGE	varchar(64)	Language of the stored routine.
PARAMETER_STYLE	varchar(8)	It is always SQL.
IS_DETERMINISTIC	varchar(3)	yes or no, depending on whether the routine is defined with the DETERMINISTIC characteristic.
SQL_DATA_ACCESS	varchar(64)	Data access characteristic for the routine.
SQL_PATH	varchar(64)	It is always null.
SECURITY_TYPE	varchar(7)	Security verification mode used when a view queries data. The value is definer or invoker.
CREATED	datetime	Date and time when the routine is created. The value is null.
LAST_ALTERED	datetime	Date and time when the routine is last modified. The value is null.
SQL_MODE	varchar(8192)	SQL mode in effect when the routine is created or altered. The value is null.
ROUTINE_COMMENT	longtext	Comment of the routine. The value is null.
DEFINER	varchar(93)	Account named in the DEFINER clause (often the user who created the routine). The value is null.
CHARACTER_SET_CLIENT	varchar(32)	Session value of a system variable when the routine is created. The value is null.
COLLATION_CONNECTION	varchar(32)	Session value of a system variable when the routine is created. The value is null.
DATABASE_COLLATION	varchar(32)	Collation of the database with which the routine is associated. The value is null.