table icon 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 true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space
Filestream Data Space ID
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On false
Tracked By Cdc false
Published false
Schema Published false
Replicated false
Replication Filter false
Merge Published false
Sync Tran Subscribed false
MS Shipped false
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) false false false
2 Name Name false false false
3 ModifiedDate datetime false false false

Identity Columns

No identity columns defined.

Primary Key Constraints

Name Is System Named Extended Property Name Extended Property Value
PK_UnitMeasure_UnitMeasureCode false 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()) false MS_Description Default constraint value of GETDATE()

Indexes

Name Index Type Primary Key Unique Unique Constraint Ignore Duplicate Key Disabled
PK_UnitMeasure_UnitMeasureCode CLUSTERED true true false false false
AK_UnitMeasure_Name NONCLUSTERED false true false false false

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 false false false No action No action false Production.BillOfMaterials
FK_Product_UnitMeasure_SizeUnitMeasureCode 1 false false false No action No action false Production.Product
FK_Product_UnitMeasure_WeightUnitMeasureCode 1 false false false No action No action false Production.Product
FK_ProductVendor_UnitMeasure_UnitMeasureCode 1 false false false No action No action false 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK_UnitMeasure_UnitMeasureCode Aug 8 2010 5:23PM 38 38 35 1 6 true 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_UnitMeasure_Name Aug 8 2010 5:23PM 38 38 38 0 22.94737 true 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]

Objects on which [UnitMeasure] depends

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