• CREATED 

The date and time when the routine was created. This is a TIMESTAMP  value. 

• LAST_ALTERED 

The date and time when the routine was last modified. This is a TIMESTAMP  value. If the routine has not been modified since its creation, this value is the same as the CREATED  value. 

• SQL_MODE 

The SQL mode in effect when the routine was created or altered, and under which the routine executes. For the permitted values, see Section 5.1.11, “Server SQL Modes” . 

• ROUTINE_COMMENT 

The text of the comment, if the routine has one. If not, this value is empty. 

• DEFINER 

The account named in the DEFINER  clause (often the user who created the routine), in ’ user_name ’@’ host_name ’  format. 

• CHARACTER_SET_CLIENT 

The session value of the character_set_client  system variable when the routine was created. 

• COLLATION_CONNECTION 

The session value of the collation_connection  system variable when the routine was created. 

## Notes 

• DATABASE_COLLATION 

The collation of the database with which the routine is associated. 

•To see information about a routine, you must be the user named as the routine DEFINER , have the SHOW_ROUTINE  privilege, have the SELECT  privilege at the global level, or have the CREATE ROUTINE , ALTER ROUTINE , or EXECUTE  privilege granted at a scope that includes the routine. The ROUTINE_DEFINITION  column is NULL  if you have only CREATE ROUTINE , ALTER ROUTINE , or EXECUTE . 

•Information about stored function return values is also available in the PARAMETERS  table. The return value row for a stored function can be identified as the row that has an ORDINAL_POSITION  value of 0. 

## 26.3.31 The INFORMATION_SCHEMA SCHEMATA Table 

A schema is a database, so the SCHEMATA  table provides information about databases. 

The SCHEMATA  table has these columns: 

• CATALOG_NAME 

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

• SCHEMA_NAME 

