The INFORMATION_SCHEMA PARTITIONS Table •The  PARAMETER_NAME  and  PARAMETER_MODE  values are  NULL  because the return value has no name and the mode does not apply. • PARAMETER_MODE • PARAMETER_NAME • DATA_TYPE • CHARACTER_MAXIMUM_LENGTH • CHARACTER_OCTET_LENGTH • NUMERIC_PRECISION • NUMERIC_SCALE • DATETIME_PRECISION • CHARACTER_SET_NAME • COLLATION_NAME • DTD_IDENTIFIER • ROUTINE_TYPE PROCEDURE  for stored procedures,  FUNCTION  for stored functions. 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. The parameter data type. For character string parameters, the collation name. For character string parameters, the character set name. For temporal parameters, the fractional seconds precision. For numeric parameters, the numeric scale. For numeric parameters, the numeric precision. For string parameters, the maximum length in bytes. For string parameters, the maximum length in characters. 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. The parameter data type. The name of the parameter. For a stored function return value, this value is  NULL . The mode of the parameter. This value is one of  IN ,  OUT , or  INOUT . For a stored function return value, this value is  NULL . 26.3.21 The INFORMATION_SCHEMA PARTITIONS Table 4804