# 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. | | `EXTERNAL_PROTOCOL_VERSION` | The protocol version configured for an external function. It has one of the following values: | *** Modified at: October 23, 2026 Source: [/db/v10/reference/information-schema-reference/cluster-component/routines/](https://docs.singlestore.com/db/v10/reference/information-schema-reference/cluster-component/routines/) (An index of the documentation is available at /llms.txt)