Object type: Index

Nonclustered index.

Details 

Table	Unique	Clustered	XML
HumanResources.EmployeeDepartmentHistory	No	No	No

Columns 

Column	Description
DepartmentID	Department in which the employee worked including currently. Foreign key to Department.DepartmentID.

Applies to

Indices | Non clustered

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