Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |
Permissions
Requires membership in the public role. For more information, see Metadata Visibility Configuration.