(mysql.info.gz) ROUTINES Table
Info Catalog
(mysql.info.gz) KEY_COLUMN_USAGE Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) VIEWS Table
21.1.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.
*Standard Name* *`mysql.proc' name* *Remarks*
`SPECIFIC_CATALOG' omit
`SPECIFIC_SCHEMA' `db' omit
`SPECIFIC_NAME' `specific_name'
`ROUTINE_CATALOG' `NULL'
`ROUTINE_SCHEMA' `db'
`ROUTINE_NAME' `name'
`MODULE_CATALOG' omit
`MODULE_SCHEMA' omit
`MODULE_NAME' omit
`USER_DEFINED_TYPE_CATALOG' omit
`USER_DEFINED_TYPE_SCHEMA' omit
`USER_DEFINED_TYPE_NAME' omit
`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'
`IS_NULL_CALL' omit
`SQL_PATH' `NULL'
`SCHEMA_LEVEL_ROUTINE' omit
`MAX_DYNAMIC_RESULT_SETS' omit
`IS_USER_DEFINED_CAST' omit
`IS_IMPLICITLY_INVOCABLE' omit
`SECURITY_TYPE' `security_type'
`TO_SQL_SPECIFIC_CATALOG' omit
`TO_SQL_SPECIFIC_SCHEMA' omit
`TO_SQL_SPECIFIC_NAME' omit
`AS_LOCATOR' omit
`CREATED' `created'
`LAST_ALTERED' `modified'
`NEW_SAVEPOINT_LEVEL' omit
`IS_UDT_DEPENDENT' omit
`RESULT_CAST_FROM_DTD_IDENTIFIER' omit
`RESULT_CAST_AS_LOCATOR' omit
`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'', then `EXTERNAL_LANGUAGE' is
`NULL'
* Otherwise, `EXTERNAL_LANGUAGE' will be what's in
`mysql.proc.language'. However, we don't have external
languages yet, so it's always `NULL'.
Info Catalog
(mysql.info.gz) KEY_COLUMN_USAGE Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) VIEWS Table
automatically generated byinfo2html