sys.parameter_type_usages

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.

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.

Change History

Release	History
14 April 2006	New content: In the description for user_type_id, added information about how to return the name of the type.