•The PARAMETER_NAME  and PARAMETER_MODE  values are NULL  because the return value has no name and the mode does not apply. 

• PARAMETER_MODE 

The mode of the parameter. This value is one of IN , OUT , or INOUT . For a stored function return value, this value is NULL . 

• PARAMETER_NAME 

The name of the parameter. For a stored function return value, this value is NULL . 

• DATA_TYPE 

The parameter data type. 

The DATA_TYPE  value is the type name only with no other information. The DTD_IDENTIFIER  value contains the type name and possibly other information such as the precision or length. 

• CHARACTER_MAXIMUM_LENGTH 

For string parameters, the maximum length in characters. 

• CHARACTER_OCTET_LENGTH 

For string parameters, the maximum length in bytes. 

• NUMERIC_PRECISION 

For numeric parameters, the numeric precision. 

• NUMERIC_SCALE 

For numeric parameters, the numeric scale. 

• DATETIME_PRECISION 

For temporal parameters, the fractional seconds precision. 

• CHARACTER_SET_NAME 

For character string parameters, the character set name. 

• COLLATION_NAME 

For character string parameters, the collation name. 

• DTD_IDENTIFIER 

The parameter data type. 

The DATA_TYPE  value is the type name only with no other information. The DTD_IDENTIFIER  value contains the type name and possibly other information such as the precision or length. 

• ROUTINE_TYPE 

PROCEDURE  for stored procedures, FUNCTION  for stored functions. 

## 26.3.21 The INFORMATION_SCHEMA PARTITIONS Table 

