Skip navigation links
About Worklog
The MySQL Worklog are design specifications for some of the items that may be considered for future development.

WL#4094: Foreign keys: without indexes on the child table

Affects: 7.1   —   Status: Un-Assigned   —   Priority: Very High 

Allow creation of foreign keys without automatic index creation
for the child table.
Or, allow dropping the automatically-created index
for the child table.
Either way, foreign keys will continue to work despite index absence.

From Peter's "WL#148 Note#1"
https://intranet.mysql.com/secure/mailarchive/mail.php?folder=4&mail=19697
"
Change#8: ...
4. If pk_column list is omitted, then pk table must have a PRIMARY KEY,
   just copy the column names from there. Try to support foreign
   key constraints if there is no key defined on the used tables.
"

From minutes of a Heidelberg discussions about foreign keys
https://inside.mysql.com/wiki/HD_Mtg:_Foreign_Keys_Workshop
"
Change#8: Agreed
Some participants said: We need *separate* WL entry for "support foreign keys
when there is no index on the child table."
Action item PeterG: Create that WL entry. 
"


Copyright (c) 2000, 2013, Oracle Corporation and/or its affiliates. All rights reserved.