DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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