| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.parameter_type_usages (Transact-SQL) |
sys.parameter_type_usages (Transact-SQL) |
rwestMSFT |
randolphwest |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Returns one row for each parameter that is of user-defined type.
Note
This view does not return rows for parameters of numbered procedures.
| Column name | Data type | Description |
|---|---|---|
| object_id | int | ID of the object to which this parameter belongs. |
| parameter_id | int | ID of the parameter. Is unique within the object. |
| user_type_id | int | ID of the user-defined type. To return the name of the type, join to the sys.types catalog view on this column. |
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
Scalar Types Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)