UnitMeasure Table (AdventureWorks)

Is a lookup table that contains the codes and descriptions of the standard units of measure. For example, the unit of measure code for liter is L.

UnitMeasure Table Definition

The UnitMeasure table is contained in the Production schema.

Column

Data type

Nullability

Description

UnitMeasureCode

nchar(3)

Not null

Primary key.

Name

Name (user-defined type)

nvarchar(50)

Not null

Description of the unit of measure.

ModifiedDate

datetime

Not null

Date and time the row was last updated.