PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID Index
Information
| Property | Value |
|---|---|
| Name | PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID |
| Type | Clustered |
| Primary | |
| Unique | |
| Table | HumanResources.EmployeeDepartmentHistory |
Columns
| Name | Type | Descending |
|---|---|---|
| EmployeeID | int | |
| StartDate | datetime | |
| DepartmentID | smallint | |
| ShiftID | tinyint | |