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.

See Also

Reference

Address Table (AdventureWorks)
AddressType Table (AdventureWorks)
Vendor Table (AdventureWorks)
VendorContact Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance