Results 1 to 4 of 4

Thread: Databases compound key vs composite key?

  1. #1
    Join Date
    Nov 2012
    Beans
    43

    Databases compound key vs composite key?

    Hello. Can someone please explain, in simple terms, what are the differences between a compound key and a composite key? Please give examples of both if possible.

  2. #2
    Join Date
    May 2007
    Location
    Leeds, UK
    Beans
    1,664
    Distro
    Ubuntu 13.10 Saucy Salamander

    Re: Databases compound key vs composite key?

    See:

    http://en.wikipedia.org/wiki/Compound_key
    http://dba.stackexchange.com/questio...-compound-keys

    It's a subtle distinction typical of a homework or exam question.
    Last edited by r-senior; April 1st, 2013 at 12:35 PM.
    Please create new threads for new questions.
    Please wrap code in code tags using the '#' button or enter it in your post like this: [code]...[/code].

  3. #3
    Join Date
    Nov 2012
    Beans
    43

    Re: Databases compound key vs composite key?

    Thanks.

  4. #4
    Join Date
    Nov 2012
    Location
    Halloween Town
    Beans
    Hidden!
    Distro
    Xubuntu Development Release

    Re: Databases compound key vs composite key?

    Compound keys occur when the DB schema specifically uses more than one column to form the primary key, composite keys are generated when no PK (primary key) is designated in the database at time of import.
    Please mark your thread as solved if you get a satisfactory response.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •