The INFORMATION_SCHEMA ROUTINES Table For stored function temporal return values, the fractional seconds precision. If the routine is a stored procedure, this value is  NULL . For stored function character string return values, the character set name. If the routine is a stored procedure, this value is  NULL . For stored function character string return values, the collation name. If the routine is a stored procedure, this value is  NULL . 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. The language used for the routine definition. This value is always  SQL . The text of the SQL statement executed by the routine. This value is always  NULL . The language of the stored routine. The value is read from the  external_language  column of the mysql.routines  data dictionary table. This value is always  SQL . YES  or  NO , depending on whether the routine is defined with the  DETERMINISTIC  characteristic. The data access characteristic for the routine. The value is one of  CONTAINS SQL ,  NO SQL ,  READS SQL DATA , or  MODIFIES SQL DATA . This value is always  NULL . The routine  SQL SECURITY  characteristic. The value is one of  DEFINER  or  INVOKER . 4817 • CHARACTER_SET_NAME • COLLATION_NAME • DTD_IDENTIFIER • ROUTINE_BODY • ROUTINE_DEFINITION • EXTERNAL_NAME • EXTERNAL_LANGUAGE • PARAMETER_STYLE • IS_DETERMINISTIC • SQL_DATA_ACCESS • SQL_PATH • SECURITY_TYPE