Share via


ScrapReason Table (AdventureWorks)

In a lookup table that contains the reasons for manufacturing failures.

ScrapReason Table Definition

The ScrapReason table is contained in the Production schema.

Column Data type Nullability Description

ScrapReasonID

smallint

Not null

Primary key.

Name

Name (user-defined type)

nvarchar(50)

Not null

Failure description.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

Product Table (AdventureWorks)
WorkOrder Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance