Re: Equivalent for all_catalog
Posted by:
Bob Field
Date: June 14, 2006 02:04PM
Some notes here on foreign key constraints:
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html
In particular note this bit:
"In the referenced table, there must be an index where the referenced columns are listed as the first columns in the same order."
So it's nothing to do with the auto_increment attribute, only that an additional index is required on the column that is to be referenced from the other table. This apparently does not have to be a UNIQUE key according to the above excerpt.
Subject
Views
Written By
Posted
5792
June 14, 2006 08:54AM
2568
June 14, 2006 09:04AM
3148
June 14, 2006 09:25AM
2457
June 14, 2006 11:13AM
2818
June 14, 2006 11:22AM
2539
June 14, 2006 11:31AM
2959
June 14, 2006 11:39AM
2733
June 14, 2006 11:52AM
Re: Equivalent for all_catalog
2639
June 14, 2006 02:04PM
2636
June 14, 2006 06:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.