Home Forums Article Discussions Article Discussions by Author Discuss content posted by Phil Factor Is a Primary Key an index? RE: Is a Primary Key an index?

  • July 18, 2014 at 12:03 am

    #1730496

    Koen Verbeeck (7/17/2014)

    Sergiy (7/16/2014)

    Koen Verbeeck (7/16/2014)

    So it is 100% possible to decouple the primary key from the index

    Can you illustrate how?

    Easy peasy. I draw a table diagram in Visio and declare the combination of a few columns to be the primary key.

    (in other words, I am creating the logical design)

    Where do you see an index?

    I do not see a primery key here either.

    I do not even see a database.

    It's just a set of drawings, labels, indicated intentions.

    As soon you try to turn it into an actual database and actually create that PK the corresponding index will be there.

    _____________
    Code for TallyGenerator