0 out of 1 rated this helpful - Rate this topic

sys.parameter_type_usages

SQL Server 2005

Updated: 14 April 2006

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.

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.

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions