Northwind Database (Document! X Sample)
AdventureWorks Database / Person Schema / Person.PersonPhone Table / PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID Index
In This Topic
    PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID 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 KeyBusinessEntityIDBusiness entity identification number. Foreign key to Person.BusinessEntityID.Ascending
    Primary KeyPhoneNumberTelephone number identification number.Ascending
    Primary KeyPhoneNumberTypeIDKind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.Ascending
    Index Statistics
    Average key length38.44
    Density1.00
    Rows in the Table19972
    Rows Sampled19972
    Distribution Steps9
    UpdatedOct 27 2017 2:33PM
    See Also

    Related Objects

    Person.PersonPhone Table
    Person Schema
    AdventureWorks Database

     

     

    © 2018 All Rights Reserved.

    Send comments on this topic.