Deployment scripts don't retain the names of foreign keys. Should use the CONSTRAINT `name` syntax when generating the script.
Having foreign key constrains renamed things like 'ibfk3' causes maintenance problems. When generating an update script, the tool should retain the name of the foreign key by using the CONSTRAINT `nameof_constraint` syntax before the FOREIGN KEY keywords.
5
votes
Russ Fuja
shared this idea