Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Foreign keys in MySQL and referential integrity of Database

Reply
Thread Tools

Foreign keys in MySQL and referential integrity of Database

 
 
Weasley
Guest
Posts: n/a
 
      02-02-2010
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...y-in-database/
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
referential integrity xsd schema file Paul Daly XML 0 01-12-2007 05:12 PM
A matter of style and referential integrity! earthling XML 0 03-15-2005 09:01 AM
Business Rules & Referential Integrity Paul Johnson ASP .Net 0 11-20-2004 04:41 PM
Database design - enforcing referential integrity on control tables? (sql server and asp 3.0) ASP General 2 08-13-2004 03:34 PM
Mysql referential integrity terry Java 1 09-09-2003 02:04 PM



Advertisments