parameters

The parameters view provides parameters about stored procedures and storage functions, as well as information about the return values of storage functions. For details, see Table 1. 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. This is not supported in this version, and the value is null.
CHARACTER_OCTET_LENGTH	integer	Maximum length of string parameters, in bytes. This is not supported in this version, and the value is null.
NUMERIC_PRECISION	bigint	Precision of numeric parameters. This is not supported in this version, and the value is null.
NUMERIC_SCALE	integer	Scale of numeric parameters. This is not supported in this version, and the value is null.
DATETIME_PRECISION	bigint	Precision of fractional seconds in temporal parameters. This is not supported in this version, and the value is null.
CHARACTER_SET_NAME	varchar(64)	Character set name of character string parameters. This is not supported in this version, and the value is null.
COLLATION_NAME	varchar(64)	Collation name of character string parameters. This is not supported in this version, and the value is null.
DTD_IDENTIFIER	longtext	Data type of the parameter.
ROUTINE_TYPE	varchar(9)	procedure: stored procedure function: stored function