ROUTINES

This view contains information about routines in a workspace.

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

The setting of the character_set_client engine variable at the creation of a given routine.

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.

Last modified: March 8, 2024

Was this article helpful?