(mysql.info) routines-table
Info Catalog
(mysql.info) key-column-usage-table
(mysql.info) information-schema
(mysql.info) views-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'.
Info Catalog
(mysql.info) key-column-usage-table
(mysql.info) information-schema
(mysql.info) views-table
automatically generated byinfo2html