Information Schema PARAMETERS Table

Stored routine name.

ORDINAL_POSITION

Ordinal position of the parameter, starting at 1. 0 for a function RETURNS clause.

PARAMETER_DEFAULT

Displays default values for stored routine parameters.

PARAMETER_MODE

One of IN, OUT, INOUT or NULL for RETURNS.

PARAMETER_NAME

Name of the parameter, or NULL for RETURNS.

DATA_TYPE

The column's data type.

CHARACTER_MAXIMUM_LENGTH

Maximum length.

CHARACTER_OCTET_LENGTH

Same as the CHARACTER_MAXIMUM_LENGTH except for multi-byte character sets.

NUMERIC_PRECISION

For numeric types, the precision (number of significant digits) for the column. NULL if not a numeric field.

NUMERIC_SCALE

For numeric types, the scale (significant digits to the right of the decimal point). NULL if not a numeric field.

DATETIME_PRECISION

Fractional-seconds precision, or NULL if not a time data type.

CHARACTER_SET_NAME

Character set if a non-binary string data type, otherwise NULL.

COLLATION_NAME

Collation if a non-binary string data type, otherwise NULL.

DTD_IDENTIFIER

Description of the data type.

ROUTINE_TYPE

PROCEDURE or FUNCTION.

PARAMETER_DEFAULT

Default parameter value. From .