Object type: Index

Nonclustered index.

Details 

Table	Unique	Clustered	XML
HumanResources.EmployeeDepartmentHistory	No	No	No

Columns 

Column	Description
ShiftID	Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.

Applies to

Indices | Non clustered

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