The INFORMATION_SCHEMA SCHEMATA Table • CREATED • LAST_ALTERED • SQL_MODE • ROUTINE_COMMENT • DEFINER • CHARACTER_SET_CLIENT • COLLATION_CONNECTION • DATABASE_COLLATION •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. • CATALOG_NAME • SCHEMA_NAME The date and time when the routine was created. This is a  TIMESTAMP  value. 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. 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” . The text of the comment, if the routine has one. If not, this value is empty. The account named in the  DEFINER  clause (often the user who created the routine), in ’ user_name ’@’ host_name ’  format. The session value of the  character_set_client  system variable when the routine was created. The session value of the  collation_connection  system variable when the routine was created. The collation of the database with which the routine is associated. A schema is a database, so the  SCHEMATA  table provides information about databases. The  SCHEMATA  table has these columns: The name of the catalog to which the schema belongs. This value is always  def . Notes 26.3.31 The INFORMATION_SCHEMA SCHEMATA Table 4818