Home Forums Article Discussions Article Discussions by Author Discuss content posted by Martin Collazos List Table Foreign Keys, Primary key and indexes RE: List Table Foreign Keys, Primary key and indexes

  • February 18, 2014 at 8:02 am

    #1689923

    Results for "index"portion are not reliable - they show multiple columns. Example:

    table Reader with the following columns:

    DeviceID, DoorTypeID, ReaderTypeID, DegradedMode, KeypadPresent, AntipassbackTime, GuestSignout, EgressAreaID, GuestSignin, AutoRelock, HasAssociatedOtisDEC, OEInterfaceID, OtisDECHostname, OEOperationModeID, ReaderModel, FirmwareVersion, EvaluationNumber

    and two indexes:

    XIF4Reader - [EgressAreaID] ASC

    PK__Reader__7FCE2F09 - DeviceID (from PK)

    is listed as:

    IDX.index_idIDX.nameIDX.type_descIDX.is_primary_keyIDX.index_column_idIDX.column_idIDX.column_nameIDX.key_ordinal

    1PK__Reader__7FCE2F09CLUSTERED111DeviceID1

    1PK__Reader__7FCE2F09CLUSTERED118EgressAreaID1

    2XIF4ReaderNONCLUSTERED018EgressAreaID1

    2XIF4ReaderNONCLUSTERED011DeviceID1