ROUTINES
Preview
This feature is in Public Preview.
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above Unity Catalog only
INFORMATION_SCHEMA.ROUTINES lists the routines (functions) within the catalog.
The rows returned are limited to the routines the user is privileged to interact with.
Definition
The ROUTINES
relation contains the following columns:
Name |
Data type |
Nullable |
Standard |
Description |
---|---|---|---|---|
|
|
No |
Yes |
Catalog containing the routine. |
|
|
No |
Yes |
Database (schema) containing the routine. |
|
|
No |
Yes |
Schema unique (specific) name of the routine. |
|
|
No |
Yes |
Matches |
|
|
No |
Yes |
Matches |
|
|
No |
Yes |
Name of the routine. |
|
|
No |
Yes |
Always |
|
|
No |
Yes |
The result data type name, or |
|
|
No |
No |
The result data type definition, for example |
|
|
Yes |
Yes |
Always |
|
|
Yes |
Yes |
Always |
|
|
Yes |
Yes |
For base-2 integral numeric types, |
|
|
Yes |
Yes |
For |
|
|
Yes |
Yes |
For integral numeric types 0, for |
|
|
Yes |
Yes |
For |
|
|
Yes |
Yes |
For |
|
|
Yes |
Yes |
Always |
|
|
Yes |
Yes |
Always |
|
|
No |
Yes |
|
|
|
Yes |
Yes |
The full definition of the routine. |
|
|
Yes |
Yes |
Always |
|
|
Yes |
Yes |
Always |
|
|
Yes |
Yes |
|
|
|
No |
Yes |
|
|
|
No |
Yes |
|
|
|
Yes |
Yes |
Always |
|
|
Yes |
Yes |
Always |
|
|
No |
Yes |
Always |
|
|
No |
Yes |
Always |
|
|
Yes |
No |
An optional comment describing the routine. |
|
|
No |
No |
Timestamp when the routine was created. |
|
|
No |
No |
Principal which created the routine. |
|
|
No |
No |
Timestamp when the routine definition was last altered in any way. |
|
|
No |
No |
Principal which last altered the routine. |
Constraints
The following constraints apply to the ROUTINES
relation:
Class |
Name |
Column List |
Description |
---|---|---|---|
Primary key |
|
|
Uniquely identifies the routine. |
Foreign key |
|
|
References SCHEMATA |