routines

routines contains all stored routines (stored procedures and stored functions).

The following fields are provided in routine:

Field	Description
SPECIFIC_NAME	The name of the routine.
ROUTINE_CATALOG	The name of the catalog to which the routine belongs. This value is always def.
ROUTINE_SCHEMA	The name of the database to which the routine belongs.
ROUTINE_NAME	The name of the routine.
ROUTINE_TYPE	PROCEDURE for stored procedures, FUNCTION for stored functions.
DTD_IDENTIFIER	If the routine is a stored function, the return value data type. If the routine is a stored procedure, this value is empty.
ROUTINE_BODY	The language used for the routine definition. This value is always SQL.
ROUTINE_DEFINITION	The text of the SQL statement executed by the routine.
EXTERNAL_NAME	This value is always NULL.
EXTERNAL_LANGUAGE	The language of the stored routine.
PARAMETER_STYLE	This value is always SQL.
IS_DETERMINISTIC	YES or NO, depending on whether the routine is defined with the DETERMINISTIC characteristic.
SQL_DATA_ACCESS	The data access characteristic for the routine. The value is one of CONTAINS SQL, NO SQL, READS SQL DATA, or MODIFIES SQL DATA.
SQL_PATH	This value is always NULL.
SECURITY_TYPE	The routine SQL SECURITY characteristic. The value is one of DEFINER or INVOKER.
CREATED	The date and time when the routine was created. This is a DATETIME value.
LAST_ALTERED	The date and time when the routine was last modified. This is a DATETIME value. If the routine has not been modified since its creation, this value is the same as the CREATED value.
SQL_MODE	The SQL mode in effect when the routine was created or altered, and under which the routine executes.
ROUTINE_COMMENT	The text of the comment, if the routine has one. If not, this value is empty.
DEFINER	The user named in the DEFINER clause (often the user who created the routine).
CHARACTER_SET_CLIENT
COLLATION_CONNECTION
DATABASE_COLLATION	The collation of the database with which the routine is associated.