← All tables and views

AdventureWorks OLTP table

Production.UnitMeasure

Unit of measure lookup table.

38rows

3 columns

Schema from the provider contract
ColumnTypeNullableKeyReferences
UnitMeasureCodeTEXTnoPK—
NameTEXTno——
ModifiedDateTEXTno——

Keys and unique indexes

Physical SQLite metadata

Primary key is declared above.

Additional unique keys

Production_UnitMeasure_AK_UnitMeasure_NameName
2 unique indexes inspected
Production_UnitMeasure_AK_UnitMeasure_NameNameCREATE UNIQUE INDEX "Production_UnitMeasure_AK_UnitMeasure_Name" ON "Production.UnitMeasure" ("Name")
sqlite_autoindex_Production.UnitMeasure_1UnitMeasureCode

Data preview

Sample records

38 rows available
UnitMeasureCodeNameModifiedDate
BOXBoxes2019-04-30 00:00:00.000
BTLBottle2019-04-30 00:00:00.000
C Celsius2019-04-30 00:00:00.000
CANCanister2019-04-30 00:00:00.000
CARCarton2019-04-30 00:00:00.000
CBMCubic meters2019-04-30 00:00:00.000
CCMCubic centimeter2019-04-30 00:00:00.000
CDMCubic decimeter2019-04-30 00:00:00.000

Interactive explorer

Explore Production.UnitMeasure

Powered by DataTug