parameters

The parameters view provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. This view does not include built-in or loadable functions. This view is read-only. All users have the read permission on this view.

**Table 1** information_schema.parameters columns
Name	Type	Description
SPECIFIC_CATALOG	varchar(512)	Name of the catalog to which the routine containing the parameter belongs. The value is the name of the current database. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
SPECIFIC_SCHEMA	varchar(64)	Name of the schema to which the routine containing the parameter belongs. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive.
SPECIFIC_NAME	varchar(64)	Name of the routine containing the parameter.
ORDINAL_POSITION	integer	For successive parameters of a stored procedure or function, the values of ordinal_position are 1, 2, 3, and so forth.
PARAMETER_MODE	varchar(5)	Mode of the parameter. The value is in, out, or inout. The value is null for a stored function return value.
PARAMETER_NAME	varchar(64)	Name of the parameter. The value is null for a stored function return value.
DATA_TYPE	varchar(64)	Data type of the parameter.
CHARACTER_MAXIMUM_LENGTH	integer	Maximum length of string parameters, in characters.
CHARACTER_OCTET_LENGTH	integer	Maximum length of string parameters, in bytes.
NUMERIC_PRECISION	bigint	Precision of numeric parameters.
NUMERIC_SCALE	integer	Scale of numeric parameters.
DATETIME_PRECISION	bigint	Precision of fractional seconds in temporal parameters.
CHARACTER_SET_NAME	varchar(64)	Character set name of character string parameters.
COLLATION_NAME	varchar(64)	Collation name of character string parameters.
DTD_IDENTIFIER	longtext	Data type of the parameter.
ROUTINE_TYPE	varchar(9)	procedure: stored procedure function: stored function