sys.parameter_type_usages

Description

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

Permissions

Article • 02/28/2023 Description ID of the object to which this parameter belongs. ID of the parameter. Is unique within the object. 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 role. For more information, see Metadata Visibility Configuration. Scalar Types Catalog Views (Transact-SQL) Catalog Views (Transact-SQL) ７ Note This view does not return rows for parameters of numbered procedures. ﾉ Expand table See Also