Foreign keys and references?

Foreign keys and references?

am 08.02.2006 17:00:57 von Tony Peardon

Could some please quickly explain the difference between a foreign key and a
reference? Thanks.

Re: Foreign keys and references?

am 08.02.2006 17:27:21 von Shion

Tony Peardon wrote:
> Could some please quickly explain the difference between a foreign key and a
> reference? Thanks.

http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-co nstraints.html


//Aho

Re: Foreign keys and references?

am 23.02.2006 01:46:08 von Jim Michaels

"J.O. Aho" wrote in message
news:44ukfaF42ddbU1@individual.net...
> Tony Peardon wrote:
>> Could some please quickly explain the difference between a foreign key
>> and a
>> reference? Thanks.
>
> http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
> http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-co nstraints.html
>
>
> //Aho

I think what he's saying is that a foreign key refers to ("REFERENCES") a
primary key. the relationship is the reference if I'm not mistaken.