Class ScalarTypesSchema.ColumnTypeUsage

sys.column_type_usages (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains one row for each column that is of user-defined type.

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

Properties

ID of the column. Is unique within the object.

[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }

objects (sys.objects)

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

ID of the object to which this column belongs.

[Column("object_id")]
[NotNull]
public int ObjectID { 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; }