Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
ROUTINES
This view contains information about routines in a cluster.
Column Name |
Description |
---|---|
|
The name of a given routine. |
|
The related catalog for a given routine. |
|
The related schema (database) for a given routine. |
|
The name of a given routine. |
|
The type of routine a given parameter is associated with: |
|
The data type of a given routine. |
|
The maximum length, in number of characters, returned by a given routine. |
|
The maximum length, in bytes, returned by a given routine. |
|
The numeric precision (maximum number of digits present in a number) for the return of a given routine. |
|
The numeric scale (maximum number of digits to the right the decimal point in a number) for the return to a given routine. |
|
The related character set name returned by a given routine. |
|
The related collation name returned by a given routine. |
|
The data type returned by a given routine. |
|
The language used to define a given routine. |
|
The SQL statement executed by a given routine. |
|
This value is always |
|
The language of the routine. |
|
This value is always |
|
This value is always |
|
This value is always |
|
The timestamp at which a given routine was created. |
|
The timestamp at which a given routine was last updated. |
|
The setting of the |
|
Comments (if any) left during the creation of a given routine. |
|
The user who created a given routine. |
|
This column is only included for command compatibility with MySQL. |
|
The setting of the |
|
The related collation for a given routine. |
|
The fractional-seconds precision of the column: |
Last modified: May 21, 2025