.png)
sys.parameter_type_usages (Transact-SQL)
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.
