Export (0) Print
Expand All

PARAMETERS

SQL Server 2000

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) System-supplied data type.
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.

See Also

syscolumns

sysobjects

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft