DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(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