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. Advertisements

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:
    725
    Paul Johnson
    Nov 20, 2004
  2. Nightcrawler
    Replies:
    0
    Views:
    542
    Nightcrawler
    Nov 10, 2005
  3. terry

    Mysql referential integrity

    terry, Sep 9, 2003, in forum: Java
    Replies:
    1
    Views:
    573
    SS Tsay
    Sep 9, 2003
  4. earthling
    Replies:
    0
    Views:
    481
    earthling
    Mar 15, 2005
  5. H5N1
    Replies:
    0
    Views:
    595
  6. Harry George
    Replies:
    9
    Views:
    913
    sonal
    Jun 13, 2006
  7. Paul Daly
    Replies:
    0
    Views:
    608
    Paul Daly
    Jan 12, 2007
  8. Guest
    Replies:
    2
    Views:
    278
    Guest
    Aug 13, 2004
Loading...