Export (0) Print
Expand All

sys.parameter_type_usages

Updated: 14 April 2006

Returns one row for each parameter that is of user-defined type.

ms187995.note(en-US,SQL.90).gifNote:
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.

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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft