# Table: UnitMeasure

## Properties

Property | Value
--- | ---
Name | UnitMeasure
ID | 478624748
Owner | dbo
Schema | Production
Filegroup | PRIMARY
Data Size (KB) | 8 KB
Index Size (KB) | 24 KB
Rows | 38
Unused (KB) | 0 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:40 PM
Create Date | 8/8/2010 5:21:54 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Unit of measure lookup table.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | UnitMeasureCode | nchar(3) |  |  |
2 | Name | Name |  |  |
3 | ModifiedDate | datetime |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_UnitMeasure_UnitMeasureCode |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
UnitMeasureCode

## Foreign Keys

No foreign keys defined.

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_UnitMeasure_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_UnitMeasure_UnitMeasureCode | CLUSTERED |  |  |  |  |
AK_UnitMeasure_Name | NONCLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object
--- | --- | --- | --- | --- | --- | --- | --- | ---
FK_BillOfMaterials_UnitMeasure_UnitMeasureCode | 1 |  |  |  | No action | No action |  | Production.BillOfMaterials
FK_Product_UnitMeasure_SizeUnitMeasureCode | 1 |  |  |  | No action | No action |  | Production.Product
FK_Product_UnitMeasure_WeightUnitMeasureCode | 1 |  |  |  | No action | No action |  | Production.Product
FK_ProductVendor_UnitMeasure_UnitMeasureCode | 1 |  |  |  | No action | No action |  | Purchasing.ProductVendor

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_UnitMeasure_UnitMeasureCode | Aug 8 2010 5:23PM | 38 | 38 | 35 | 1 | 6 |  |  | 38

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.02631579 | 6 | UnitMeasureCode

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
BOX | 0 | 1 | 0 | 1
BTL | 0 | 1 | 0 | 1
C | 0 | 1 | 0 | 1
CAN | 0 | 1 | 0 | 1
CAR | 0 | 1 | 0 | 1
CBM | 0 | 1 | 0 | 1
CCM | 0 | 1 | 0 | 1
CDM | 0 | 1 | 0 | 1
CM | 0 | 1 | 0 | 1
CM2 | 0 | 1 | 0 | 1
CR | 0 | 1 | 0 | 1
CTN | 1 | 1 | 1 | 1
DM | 0 | 1 | 0 | 1
DZ | 0 | 1 | 0 | 1
EA | 0 | 1 | 0 | 1
GAL | 2 | 1 | 2 | 1
IN | 0 | 1 | 0 | 1
KG | 0 | 1 | 0 | 1
KGV | 0 | 1 | 0 | 1
KM | 0 | 1 | 0 | 1
KT | 0 | 1 | 0 | 1
L | 0 | 1 | 0 | 1
LB | 0 | 1 | 0 | 1
M | 0 | 1 | 0 | 1
M2 | 0 | 1 | 0 | 1
M3 | 0 | 1 | 0 | 1
MG | 0 | 1 | 0 | 1
ML | 0 | 1 | 0 | 1
MM | 0 | 1 | 0 | 1
OZ | 0 | 1 | 0 | 1
PAK | 0 | 1 | 0 | 1
PAL | 0 | 1 | 0 | 1
PC | 0 | 1 | 0 | 1
PCT | 0 | 1 | 0 | 1
PT | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_UnitMeasure_Name | Aug 8 2010 5:23PM | 38 | 38 | 38 | 0 | 22.94737 |  |  | 38

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.02631579 | 16.94737 | Name
0.02631579 | 22.94737 | Name, UnitMeasureCode

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
Bottle | 0 | 1 | 0 | 1
Boxes | 0 | 1 | 0 | 1
Canister | 0 | 1 | 0 | 1
Carton | 0 | 1 | 0 | 1
Case | 0 | 1 | 0 | 1
Celsius | 0 | 1 | 0 | 1
Centimeter | 0 | 1 | 0 | 1
Container | 0 | 1 | 0 | 1
Crate | 0 | 1 | 0 | 1
Cubic centimeter | 0 | 1 | 0 | 1
Cubic decimeter | 0 | 1 | 0 | 1
Cubic foot | 0 | 1 | 0 | 1
Cubic meter | 0 | 1 | 0 | 1
Cubic meters | 0 | 1 | 0 | 1
Decimeter | 0 | 1 | 0 | 1
Dozen | 0 | 1 | 0 | 1
Each | 0 | 1 | 0 | 1
Gallon | 0 | 1 | 0 | 1
Gram | 0 | 1 | 0 | 1
Inch | 0 | 1 | 0 | 1
Kilogram | 0 | 1 | 0 | 1
Kilogram/cubic meter | 0 | 1 | 0 | 1
Kilometer | 0 | 1 | 0 | 1
Kiloton | 0 | 1 | 0 | 1
Liter | 0 | 1 | 0 | 1
Meter | 0 | 1 | 0 | 1
Milligram | 0 | 1 | 0 | 1
Milliliter | 0 | 1 | 0 | 1
Millimeter | 0 | 1 | 0 | 1
Ounces | 0 | 1 | 0 | 1
Pack | 0 | 1 | 0 | 1
Pallet | 0 | 1 | 0 | 1
Percentage | 0 | 1 | 0 | 1
Piece | 0 | 1 | 0 | 1
Pint, US liquid | 0 | 1 | 0 | 1
Square centimeter | 0 | 1 | 0 | 1
Square meter | 0 | 1 | 0 | 1
US pound | 0 | 1 | 0 | 1

## Objects that depend on [UnitMeasure]

- Production.UnitMeasure
  - Production.BillOfMaterials
    - dbo.uspGetBillOfMaterials
      - HumanResources.ProcedureSynonym
    - dbo.uspGetWhereUsedProductID
  - Production.Product
    - dbo.KrystianProductView
    - dbo.ufnGetProductDealerPrice
      - Person.functionSynonym
    - dbo.ufnGetProductListPrice
    - dbo.ufnGetProductStandardCost
    - Production.ProductCostHistory
    - Production.ProductDocument
    - Production.ProductInventory
      - dbo.ufnGetStock
    - Production.ProductListPriceHistory
    - Production.ProductProductPhoto
    - Production.ProductReview
    - Production.TransactionHistory
      - Production.WorkOrder
        - Production.iWorkOrder
        - Production.uWorkOrder
        - Production.WorkOrderRouting
      - Purchasing.PurchaseOrderDetail
        - Purchasing.iPurchaseOrderDetail
        - Purchasing.uPurchaseOrderDetail
      - Sales.SalesOrderDetail
        - Sales.iduSalesOrderDetail
        - Sales.ufn_SalesByStore
    - Production.uspGetList
    - Production.vProductAndDescription
    - Purchasing.ProductVendor
    - Sales.ShoppingCartItem
    - Sales.SpecialOfferProduct

## Objects on which [UnitMeasure] depends

- Production.UnitMeasure
  - dbo.Name

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Production].[UnitMeasure]( [UnitMeasureCode] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Name] [dbo].[Name] NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'UnitMeasure', @level2type=N'COLUMN',@level2name=N'UnitMeasureCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unit of measure description.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'UnitMeasure', @level2type=N'COLUMN',@level2name=N'Name' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'UnitMeasure', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unit of measure lookup table.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'UnitMeasure'

#### See also

List of Tables