routines
note
This view does not apply to the available features in StarRocks.
routines contains all stored routines (stored procedures and stored functions).
The following fields are provided in routine:
| Field | Description |
|---|---|
| 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 database to which the routine belongs. |
| ROUTINE_NAME | The name of the routine. |
| ROUTINE_TYPE | PROCEDURE for stored procedures, FUNCTION for stored functions. |
| 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. |
| 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. |
| 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. |
| CREATED | The date and time when the routine was created. This is a DATETIME value. |
| LAST_ALTERED | The date and time when the routine was last modified. This is a DATETIME 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. |
| ROUTINE_COMMENT | The text of the comment, if the routine has one. If not, this value is empty. |
| DEFINER | The user named in the DEFINER clause (often the user who created the routine). |
| CHARACTER_SET_CLIENT | |
| COLLATION_CONNECTION | |
| DATABASE_COLLATION | The collation of the database with which the routine is associated. |