20.14. The INFORMATION_SCHEMA ROUTINES Table

20.14. The `INFORMATION_SCHEMA ROUTINES` Table

The ROUTINES table provides information about stored routines (both procedures and functions). The ROUTINES table does not include user-defined functions (UDFs) at this time.

The column named “mysql.proc name” indicates the mysql.proc table column that corresponds to the INFORMATION_SCHEMA.ROUTINES table column, if any.

`INFORMATION_SCHEMA` Name	`mysql.proc` Name	Remarks
`SPECIFIC_NAME`	`specific_name`
`ROUTINE_CATALOG`		`NULL`
`ROUTINE_SCHEMA`	`db`
`ROUTINE_NAME`	`name`
`ROUTINE_TYPE`	`type`	`{PROCEDURE\|FUNCTION}`
`DTD_IDENTIFIER`		(data type descriptor)
`ROUTINE_BODY`		`SQL`
`ROUTINE_DEFINITION`	`body`
`EXTERNAL_NAME`		`NULL`
`EXTERNAL_LANGUAGE`	`language`	`NULL`
`PARAMETER_STYLE`		`SQL`
`IS_DETERMINISTIC`	`is_deterministic`
`SQL_DATA_ACCESS`	`sql_data_access`
`SQL_PATH`		`NULL`
`SECURITY_TYPE`	`security_type`
`CREATED`	`created`
`LAST_ALTERED`	`modified`
`SQL_MODE`	`sql_mode`	MySQL extension
`ROUTINE_COMMENT`	`comment`	MySQL extension
`DEFINER`	`definer`	MySQL extension

Notes:

MySQL calculates EXTERNAL_LANGUAGE thus:
- If mysql.proc.language='SQL', EXTERNAL_LANGUAGE is NULL
- Otherwise, EXTERNAL_LANGUAGE is what is in mysql.proc.language. However, we do not have external languages yet, so it is always NULL.