PARAMETERS
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above Unity Catalog only
Preview
This feature is in Public Preview.
INFORMATION_SCHEMA.PARAMETERS lists the routine parameters within the catalog.
The rows returned are limited to the routines the user is privileged to interact with.
Definition
The PARAMETERS
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 |
The position (1-based) of the parameter in the routine parameter list. |
|
|
No |
Yes |
Always |
|
|
No |
Yes |
Always |
|
|
No |
Yes |
Always |
|
|
Yes |
Yes |
Name of the parameters, |
|
|
No |
Yes |
The parameter data type name. |
|
|
No |
No |
The parameter 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 |
|
|
Yes |
Yes |
Always |
|
|
Yes |
No |
An optional comment describing the parameter. |
Constraints
The following constraints apply to the PARAMETERS
relation:
Class |
Name |
Column List |
Description |
---|---|---|---|
Primary key |
|
|
Uniquely identifies the parameter. |
Foreign key |
|
|
References ROUTINES_PK |