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 

The name of the routine. 

• ROUTINE_CATALOG 

The name of the catalog to which the routine belongs. This value is always def . 

• ROUTINE_SCHEMA 

The name of the schema (database) to which the routine belongs. 

• ROUTINE_NAME 

The name of the routine. 

• ROUTINE_TYPE 

PROCEDURE  for stored procedures, FUNCTION  for stored functions. 

• DATA_TYPE 

If the routine is a stored function, the return value data type. If the routine is a stored procedure, this value is empty. 

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 stored function string return values, the maximum length in characters. If the routine is a stored procedure, this value is NULL . 

• CHARACTER_OCTET_LENGTH 

For stored function string return values, the maximum length in bytes. If the routine is a stored procedure, this value is NULL . 

• NUMERIC_PRECISION 

For stored function numeric return values, the numeric precision. If the routine is a stored procedure, this value is NULL . 

• NUMERIC_SCALE 

For stored function numeric return values, the numeric scale. If the routine is a stored procedure, this value is NULL . 

• DATETIME_PRECISION 

