Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    43

    Unanswered: Id necessary in a relationship table?

    When I use a third table to keep track of a many-to-many relationship I obviously create two columns in this third table that will hold both foreign kyes from the other two tables, but is it necessary to have an auto-increment, primary index column ("id" for example) in the relationship-table itself? Or should I just create a primary index using the two foreign keys?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the latter
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2003
    Posts
    43
    Thanks!

Posting Permissions

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