Movatterモバイル変換

SPECIFIC_NAME

The name of the routine.

ROUTINE_CATALOG

The name of the catalog to which the routine belongs. This value is alwaysdef.

ROUTINE_SCHEMA

The name of the schema (database) to which the routine belongs.

ROUTINE_NAME

The name of the routine.

ROUTINE_TYPE

PROCEDURE for stored procedures,FUNCTION for stored functions.

DATA_TYPE

If the routine is a stored function, the return value data type. If the routine is a stored procedure, this value is empty.

TheDATA_TYPE value is the type name only with no other information. TheDTD_IDENTIFIER value contains the type name and possibly other information such as the precision or length.

CHARACTER_MAXIMUM_LENGTH

For stored function string return values, the maximum length in characters. If the routine is a stored procedure, this value isNULL.

CHARACTER_OCTET_LENGTH

For stored function string return values, the maximum length in bytes. If the routine is a stored procedure, this value isNULL.

NUMERIC_PRECISION

For stored function numeric return values, the numeric precision. If the routine is a stored procedure, this value isNULL.

NUMERIC_SCALE

For stored function numeric return values, the numeric scale. If the routine is a stored procedure, this value isNULL.

DATETIME_PRECISION

For stored function temporal return values, the fractional seconds precision. If the routine is a stored procedure, this value isNULL.

CHARACTER_SET_NAME

For stored function character string return values, the character set name. If the routine is a stored procedure, this value isNULL.

COLLATION_NAME

For stored function character string return values, the collation name. If the routine is a stored procedure, this value isNULL.

DTD_IDENTIFIER

If the routine is a stored function, the return value data type. If the routine is a stored procedure, this value is empty.

TheDATA_TYPE value is the type name only with no other information. TheDTD_IDENTIFIER value contains the type name and possibly other information such as the precision or length.

ROUTINE_BODY

The language used for the routine definition. This value is alwaysSQL.

ROUTINE_DEFINITION

The text of the SQL statement executed by the routine.

EXTERNAL_NAME

This value is alwaysNULL.

EXTERNAL_LANGUAGE

The language of the stored routine. MySQL calculatesEXTERNAL_LANGUAGE thus:

PARAMETER_STYLE

This value is alwaysSQL.

IS_DETERMINISTIC

YES orNO, depending on whether the routine is defined with theDETERMINISTIC characteristic.

SQL_DATA_ACCESS

The data access characteristic for the routine. The value is one ofCONTAINS SQL,NO SQL,READS SQL DATA, orMODIFIES SQL DATA.

SQL_PATH

This value is alwaysNULL.

SECURITY_TYPE

The routineSQL SECURITY characteristic. The value is one ofDEFINER orINVOKER.

CREATED

The date and time when the routine was created. This is aTIMESTAMP value.

LAST_ALTERED

The date and time when the routine was last modified. This is aTIMESTAMP value. If the routine has not been modified since its creation, this value is the same as theCREATED value.

SQL_MODE

The SQL mode in effect when the routine was created or altered, and under which the routine executes. For the permitted values, seeSection 5.1.10, “Server SQL Modes”.

ROUTINE_COMMENT

The text of the comment, if the routine has one. If not, this value is empty.

DEFINER

The account named in theDEFINER clause (often the user who created the routine), in'user_name'@'host_name' format.

CHARACTER_SET_CLIENT

The session value of thecharacter_set_client system variable when the routine was created.

COLLATION_CONNECTION

The session value of thecollation_connection system variable when the routine was created.

DATABASE_COLLATION

The collation of the database with which the routine is associated.

To see information about a routine, you must be the user named in the routineDEFINER clause or haveSELECT access to themysql.proc table. If you do not have privileges for the routine itself, the value displayed for theROUTINE_DEFINITION column isNULL.

Information about stored function return values is also available in thePARAMETERS table. The return value row for a stored function can be identified as the row that has anORDINAL_POSITION value of 0.