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.

Last modified: March 8, 2024

Was this article helpful?