# PARAMETERS

This view contains information about parameters.

| Column Name                | Description                                                                                                                                                |
| -------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `SPECIFIC_CATALOG`         | The name of the catalog that a given parameter belongs to.                                                                                                 |
| `SPECIFIC_SCHEMA`          | The name of the related schema (database) for a given parameter.                                                                                           |
| `SPECIFIC_NAME`            | The name of the routine which contains a given parameter.                                                                                                  |
| `ORDINAL_POSITION`         | The position of a given parameter among others in a given stored procedure or other object containing a parameter.                                         |
| `PARAMETER_MODE`           | The mode of a given parameter.                                                                                                                             |
| `PARAMETER_NAME`           | The name of a given parameter.                                                                                                                             |
| `DATA_TYPE`                | The data type of a given parameter.                                                                                                                        |
| `CHARACTER_MAXIMUM_LENGTH` | The maximum length, in characters, for a given string parameter.                                                                                           |
| `CHARACTER_OCTET_LENGTH`   | The maximum length, in bytes, for a given string parameter.                                                                                                |
| `NUMERIC_PRECISION`        | The numeric precision (maximum number of digits present in a number) for a given parameter.                                                                |
| `NUMERIC_SCALE`            | The numeric scale (maximum number of digits to the right the decimal point in a number) for a given parameter.                                             |
| `CHARACTER_SET_NAME`       | The name of the related character set for a given parameter.                                                                                               |
| `COLLATION_NAME`           | The name of the related collation for a given parameter.                                                                                                   |
| `DTD_IDENTIFIER`           | This field contains the data type of a given parameter, as well as other low level information.                                                            |
| `ROUTINE_TYPE`             | The type of routine a given parameter is associated with:`PROCEDURE`or`FUNCTION`.                                                                          |
| `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. |

***

Modified at: March 8, 2024

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/parameters/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/parameters/)

(An index of the documentation is available at /llms.txt)