Foreign keys in MySQL and referential integrity of Database

Discussion in 'Java' started by Weasley, Feb 2, 2010.

  1. Weasley

    Weasley Guest

    A foreign key in a My Sql database is a field (or fields) of a table
    that points to a primary key of an other table. Such keys are defined
    in a database to ensure that only fields that supposed to appear in a
    database may be permitted.

    What is their requirement ? Why are they useful ?

    For enhancing the referential integrity of your database, you need
    foreign key. Read more on how they are defined and created. Learn
    through some examples.

    http://sulabhjain.wordpress.com/2010/02/01/foreign-keys-and-referential-integrity-in-database/
     
    Weasley, Feb 2, 2010
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Paul Johnson

    Business Rules & Referential Integrity

    Paul Johnson, Nov 20, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    597
    Paul Johnson
    Nov 20, 2004
  2. terry

    Mysql referential integrity

    terry, Sep 9, 2003, in forum: Java
    Replies:
    1
    Views:
    513
    SS Tsay
    Sep 9, 2003
  3. earthling
    Replies:
    0
    Views:
    402
    earthling
    Mar 15, 2005
  4. Paul Daly
    Replies:
    0
    Views:
    542
    Paul Daly
    Jan 12, 2007
  5. Guest
    Replies:
    2
    Views:
    185
    Guest
    Aug 13, 2004
Loading...

Share This Page