Production.UnitMeasure

Table: 'Production.UnitMeasure'

Field Name Data Type Size Original Type Default Nullable Description Check

UnitMeasureCode nchar 3 Not null Primary key.

Name Name nvarchar(50) Not null Unit of measure description.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description
UnitMeasureCode	nchar	3			Not null	Primary key.
Name	Name		nvarchar(50)		Not null	Unit of measure description.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.UnitMeasure'

Primary Key Name Field Name

PK_UnitMeasure_UnitMeasureCode UnitMeasureCode

There are no Foreign Keys for this table.

Primary Key Name	Field Name
PK_UnitMeasure_UnitMeasureCode	UnitMeasureCode

Indexes for table 'Production.UnitMeasure', 2 items

Index Name Description Clustered Unique Fields

PK_UnitMeasure_UnitMeasureCode Clustered index created by a primary key constraint. Yes Yes UnitMeasureCode

AK_UnitMeasure_Name Unique nonclustered index. No Yes Name

Index Name	Description	Clustered	Unique	Fields
PK_UnitMeasure_UnitMeasureCode	Clustered index created by a primary key constraint.	Yes	Yes	UnitMeasureCode
AK_UnitMeasure_Name	Unique nonclustered index.	No	Yes	Name

Triggers for table 'Production.UnitMeasure', 1 item

Name Description Type Enabled

uUnitMeasure AFTER UPDATE trigger setting the ModifiedDate column in the UnitMeasure table to the current date. after Update Yes

Name	Description	Type	Enabled
uUnitMeasure	AFTER UPDATE trigger setting the ModifiedDate column in the UnitMeasure table to the current date.	after Update	Yes

Dependencies for table 'Production.UnitMeasure', 1 item

Object Name Type Field Name

Production.uUnitMeasure trigger N/A