Northwind Database (Document! X Sample)
AdventureWorks Database / HumanResources Schema / HumanResources.EmployeeDepartmentHistory Table / PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID Index
In This Topic
    PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID Index
    In This Topic
    Description
    Primary key (clustered) constraint
    Properties
    File GroupPRIMARY
    Space Used16.00 KB
    Fill Factor0
    Do not Recompute Statistics
    Full Text Key
    Clustered Index
    Primary Key Index
    Unique Index
    Pad Index
    Columns
     ColumnDescriptionSort Order
    Primary KeyBusinessEntityIDEmployee identification number. Foreign key to Employee.BusinessEntityID.Ascending
    Primary KeyStartDateDate the employee started work in the department.Ascending
    Primary KeyDepartmentIDDepartment in which the employee worked including currently. Foreign key to Department.DepartmentID.Ascending
    Primary KeyShiftIDIdentifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.Ascending
    Index Statistics
    Average key length10.00
    Density1.00
    Rows in the Table296
    Rows Sampled296
    Distribution Steps150
    UpdatedOct 27 2017 2:33PM
    See Also

    Related Objects

    HumanResources.EmployeeDepartmentHistory Table
    HumanResources Schema
    AdventureWorks Database

     

     

    © 2018 All Rights Reserved.

    Send comments on this topic.