Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    Unanswered: Constraint across tables

    Is it possible to have a constraint that goes across columns in different tables...for example, if you have a UNIQUE constraint, if you add something to column A in table A, you can't add that same value to column A in table A or table B.

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    in a word: no

    in other database systems you might be able to declare a check constraint or even an assertion but mysql does not support these | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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