MariaDB starting with 5.5

The Information Schema PARAMETERS table stores information about stored procedures and stored functions parameters.

It contains the following columns:

ColumnDescription
SPECIFIC_CATALOGAlways def.
SPECIFIC_SCHEMADatabase name containing the stored routine parameter.
SPECIFIC_NAMEStored routine name.
ORDINAL_POSITIONOrdinal position of the parameter, starting at 1. 0 for a function RETURNS clause.
PARAMETER_MODEOne of IN, OUT, INOUT or NULL for RETURNS.
PARAMETER_NAMEName of the parameter, or NULL for RETURNS.
DATA_TYPEThe column's data type.
CHARACTER_MAXIMUM_LENGTHMaximum length.
CHARACTER_OCTET_LENGTHSame as the CHARACTER_MAXIMUM_LENGTH except for multi-byte character sets.
NUMERIC_PRECISIONFor numeric types, the precision (number of significant digits) for the column. NULL if not a numeric field.
NUMERIC_SCALEFor numeric types, the scale (significant digits to the right of the decimal point). NULL if not a numeric field.
DATETIME_PRECISIONFractional-seconds precision, or NULL if not a time data type.
CHARACTER_SET_NAMECharacter set if a non-binary string data type, otherwise NULL.
COLLATION_NAMECollation if a non-binary string data type, otherwise NULL.
DTD_IDENTIFIERDescription of the data type.
ROUTINE_TYPEPROCEDURE or FUNCTION.

Information from this table is similar to that found in the param_list column in the mysql.proc table, and the output of the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements.

To obtain information about the routine itself, you can query the Information Schema ROUTINES table.

Comments

Comments loading...