# ROUTINES

This view contains information about routines in a cluster.

| Column Name                | Description                                                                                                                                                                          |
| -------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `SPECIFIC_NAME`            | The name of a given routine.                                                                                                                                                         |
| `ROUTINE_CATALOG`          | The related catalog for a given routine.                                                                                                                                             |
| `ROUTINE_SCHEMA`           | The related schema (database) for a given routine.                                                                                                                                   |
| `ROUTINE_NAME`             | The name of a given routine.                                                                                                                                                         |
| `ROUTINE_TYPE`             | The type of routine a given parameter is associated with:`PROCEDURE`or`FUNCTION`.                                                                                                    |
| `DATA_TYPE`                | The data type of a given routine. If a routine is the`PROCEDURE`type, this column is`NULL`.                                                                                          |
| `CHARACTER_MAXIMUM_LENGTH` | The maximum length, in number of characters, returned by a given routine. If a routine is the`PROCEDURE`type, this column is`NULL`.                                                  |
| `CHARACTER_OCTET_LENGTH`   | The maximum length, in bytes, returned by a given routine. If a routine is the`PROCEDURE`type, this column is`NULL`.                                                                 |
| `NUMERIC_PRECISION`        | The numeric precision (maximum number of digits present in a number) for the return of a given routine. If a routine is the`PROCEDURE`type, this column is`NULL`.                    |
| `NUMERIC_SCALE`            | The numeric scale (maximum number of digits to the right the decimal point in a number) for the return to a given routine. If a routine is the`PROCEDURE`type, this column is`NULL`. |
| `CHARACTER_SET_NAME`       | The related character set name returned by a given routine. If a routine is the`PROCEDURE`type, this column is`NULL`.                                                                |
| `COLLATION_NAME`           | The related collation name returned by a given routine. If a routine is the`PROCEDURE`type, this column is`NULL`.                                                                    |
| `DTD_IDENTIFIER`           | The data type returned by a given routine. If a routine is the`PROCEDURE`type, this column is`NULL`.                                                                                 |
| `ROUTINE_BODY`             | The language used to define a given routine. This value is always`SQL`.                                                                                                              |
| `ROUTINE_DEFINITION`       | The SQL statement executed by a given routine.                                                                                                                                       |
| `EXTERNAL_NAME`            | This value is always`NULL`.                                                                                                                                                          |
| `EXTERNAL_LANGUAGE`        | The language of the routine. This value is always`SQL`.                                                                                                                              |
| `PARAMETER_STYLE`          | This value is always`SQL`.                                                                                                                                                           |
| `SQL_PATH`                 | This value is always`NULL`.                                                                                                                                                          |
| `SECURITY_TYPE`            | This value is always`DEFINER`.                                                                                                                                                       |
| `CREATED`                  | The timestamp at which a given routine was created.                                                                                                                                  |
| `LAST_ALTERED`             | The timestamp at which a given routine was last updated.                                                                                                                             |
| `SQL_MODE`                 | The setting of the`SQL_mode`engine variable at the creation of a given routine.                                                                                                      |
| `ROUTINE_COMMENT`          | Comments (if any) left during the creation of a given routine.                                                                                                                       |
| `DEFINER`                  | The user who created a given routine.                                                                                                                                                |
| `CHARACTER_SET_CLIENT`     | This column is only included for command compatibility with MySQL. The value of this variable cannot be guaranteed.                                                                  |
| `COLLATION_CONNECTION`     | The setting of the`collation_connection`engine variable at the creation of a given routine.                                                                                          |
| `DATABASE_COLLATION`       | The related collation for a given routine.                                                                                                                                           |
| `DATETIME_PRECISION`       | The fractional-seconds precision of the column:`0`for TIME, TIMESTAMP, DATETIME and`6`for DATETIME(6) columns, or NULL if the column not a time data type.                           |

***

Modified at: May 21, 2025

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/routines/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/routines/)

(An index of the documentation is available at /llms.txt)