Contains one row for each parameter of a user-defined function or stored procedure accessible to the current user in the current database. For functions, this view also returns one row with return value information.
The INFORMATION_SCHEMA.PARAMETERS view is based on the sysobjects and syscolumns system tables.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA view_name.
| Column name | Data type | Description |
|---|---|---|
| SPECIFIC_CATALOG | nvarchar(128) | Catalog name of the ROUTINE for which this is a parameter. |
| SPECIFIC_SCHEMA | nvarchar(128) | Owner name of the ROUTINE for which this is a parameter. |
| SPECIFIC_NAME | nvarchar(128) | Name of the ROUTINE for which this is a parameter. |
| ORDINAL_POSITION | smallint | Ordinal position of the parameter starting at 1. For the return value of a function, this is a 0. |
| PARAMETER_MODE | nvarchar(10) | Returns IN if an input parameter, OUT if an output parameter, and INOUT if an input/output parameter. |
| IS_RESULT | nvarchar(10) | Returns YES if indicates result of the routine that is a function. Otherwise, returns NO. |
| AS_LOCATOR | nvarchar(10) | Returns YES if declared as locator. Otherwise, returns NO. |
| PARAMETER_NAME | nvarchar(128) | Name of the parameter. NULL if this corresponds to the return value of a function. |
| DATA_TYPE | nvarchar(128) | Data type of the parameter. |
| CHARACTER_MAXIMUM_LENGTH | int | Maximum length in characters for binary or character data types. Otherwise, returns NULL. |
| CHARACTER_OCTET_LENGTH | int | Maximum length, in bytes, for binary or character data types. Otherwise, returns NULL. |
| COLLATION_CATALOG | nvarchar(128) | Catalog name of the collation of the parameter. If not one of the character types, returns NULL. |
| COLLATION_SCHEMA | nvarchar(128) | Schema name of the collation of the parameter. If not one of the character types, returns NULL. |
| COLLATION_NAME | nvarchar(128) | Name of the collation of the parameter. If not one of the character types, returns NULL. |
| CHARACTER_SET_CATALOG | nvarchar(128) | Catalog name of the character set of the parameter. If not one of the character types, returns NULL. |
| CHARACTER_SET_SCHEMA | nvarchar(128) | Owner name of the character set of the parameter. If not one of the character types, returns NULL. |
| CHARACTER_SET_NAME | nvarchar(128) | Name of the character set of the parameter. If not one of the character types, returns NULL. |
| NUMERIC_PRECISION | tinyint | Precision of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, returns NULL. |
| NUMERIC_PRECISION_RADIX | smallint | Precision radix of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, returns NULL. |
| NUMERIC_SCALE | tinyint | Scale of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, returns NULL. |
| DATETIME_PRECISION | smallint | Precision in fractional seconds if the parameter type is datetime or smalldatetime. Otherwise, returns NULL. |
| INTERVAL_TYPE | nvarchar(30) | NULL. Reserved for future use. |
| INTERVAL_PRECISION | smallint | NULL. Reserved for future use. |
| USER_DEFINED_TYPE_CATALOG | nvarchar(128) | NULL. Reserved for future use. |
| USER_DEFINED_TYPE_SCHEMA | nvarchar(128) | NULL. Reserved for future use. |
| USER_DEFINED_TYPE_NAME | nvarchar(128) | NULL. Reserved for future use. |
| SCOPE_CATALOG | nvarchar(128) | NULL. Reserved for future use. |
| SCOPE_SCHEMA | nvarchar(128) | NULL. Reserved for future use. |
| SCOPE_NAME | nvarchar(128) | NULL. Reserved for future use. |