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

• CHARACTER_SET_NAME 

For stored function character string return values, the character set name. If the routine is a stored procedure, this value is NULL . 

• COLLATION_NAME 

For stored function character string return values, the collation name. If the routine is a stored procedure, this value is NULL . 

• DTD_IDENTIFIER 

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. 

• ROUTINE_BODY 

The language used for the routine definition. This value is always SQL . 

• ROUTINE_DEFINITION 

The text of the SQL statement executed by the routine. 

• EXTERNAL_NAME 

This value is always NULL . 

• EXTERNAL_LANGUAGE 

The language of the stored routine. The value is read from the external_language  column of the mysql.routines  data dictionary table. 

• PARAMETER_STYLE 

This value is always SQL . 

• IS_DETERMINISTIC 

YES  or NO , depending on whether the routine is defined with the DETERMINISTIC  characteristic. 

• SQL_DATA_ACCESS 

The data access characteristic for the routine. The value is one of CONTAINS SQL , NO SQL , READS SQL DATA , or MODIFIES SQL DATA . 

• SQL_PATH 

This value is always NULL . 

• SECURITY_TYPE 

The routine SQL SECURITY  characteristic. The value is one of DEFINER  or INVOKER . 

