The INFORMATION_SCHEMA ROUTINES Table YES  or  NO , depending on whether the role is grantable to other accounts. 26.3.30 The INFORMATION_SCHEMA ROUTINES Table The  ROUTINES  table provides information about stored routines (stored procedures and stored functions). The  ROUTINES  table does not include built-in (native) functions or loadable functions. The  ROUTINES  table has these columns: • SPECIFIC_NAME • ROUTINE_CATALOG • ROUTINE_SCHEMA • ROUTINE_NAME • DATA_TYPE • ROUTINE_TYPE • CHARACTER_MAXIMUM_LENGTH • CHARACTER_OCTET_LENGTH • NUMERIC_PRECISION • NUMERIC_SCALE • DATETIME_PRECISION For stored function numeric return values, the numeric scale. If the routine is a stored procedure, this value is  NULL . For stored function numeric return values, the numeric precision. If the routine is a stored procedure, this value is  NULL . For stored function string return values, the maximum length in bytes. If the routine is a stored procedure, this value is  NULL . For stored function string return values, the maximum length in characters. If the routine is a stored procedure, this value is  NULL . 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. If the routine is a stored function, the return value data type. If the routine is a stored procedure, this value is empty. PROCEDURE  for stored procedures,  FUNCTION  for stored functions. The name of the routine. The name of the schema (database) to which the routine belongs. The name of the catalog to which the routine belongs. This value is always  def . The name of the routine. 4816