Object type: Index

Clustered index.

Details 

Table	Unique	Clustered	XML
Production.BillOfMaterials	Yes	Yes	No

Columns 

Column	Description
ProductAssemblyID	Parent product identification number. Foreign key to Product.ProductID.
ComponentID	Component identification number. Foreign key to Product.ProductID.
StartDate	Date the component started being used in the assembly item.

Applies to

Indices | Unique | Clustered

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation