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
5641
June 14, 2006 08:54AM
2503
June 14, 2006 09:04AM
3026
June 14, 2006 09:25AM
2396
June 14, 2006 11:13AM
2757
June 14, 2006 11:22AM
2478
June 14, 2006 11:31AM
2892
June 14, 2006 11:39AM
2675
June 14, 2006 11:52AM
Re: Equivalent for all_catalog
2579
June 14, 2006 02:04PM
2577
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.