PARAMETERS
This view contains information about parameters.
Column Name | Description |
|---|---|
| The name of the catalog that a given parameter belongs to. |
| The name of the related schema (database) for a given parameter. |
| The name of the routine which contains a given parameter. |
| The position of a given parameter among others in a given stored procedure or other object containing a parameter. |
| The mode of a given parameter. |
| The name of a given parameter. |
| The data type of a given parameter. |
| The maximum length, in characters, for a given string parameter. |
| The maximum length, in bytes, for a given string parameter. |
| The numeric precision (maximum number of digits present in a number) for a given parameter. |
| The numeric scale (maximum number of digits to the right the decimal point in a number) for a given parameter. |
| The name of the related character set for a given parameter. |
| The name of the related collation for a given parameter. |
| This field contains the datatype of a given parameter, as well as other low level information. |
| The type of routine a given parameter is associated with: |