Class ScalarTypesSchema.ParameterTypeUsage

sys.parameter_type_usages (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

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

This view does not return rows for parameters of numbered procedures.

[Table(Schema = "sys", Name = "parameter_type_usages", IsView = true)]
public class ScalarTypesSchema.ParameterTypeUsage

Properties

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

ID of the object to which this parameter belongs.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

ID of the parameter. Is unique within the object.

[Column("parameter_id")]
[NotNull]
public int ParameterID { get; set; }

ID of the user-defined type.

To return the name of the type, join to the sys.types catalog view on this column.

[Column("user_type_id")]
[NotNull]
public int UserTypeID { get; set; }