Trying to create a foreign key, but doesn't allow me to save the changes as it shows the error "Please specify covering index name." Cant specify the covering index unless i toggle the auto fk index switch. Which is disabled. I was able to create two otherenter image description here foreign keys with no issue.

  • Welcome to the network :) Please provide the create table statements for all objects involved. Also see minimal reproducible example & How to Ask for tips to help make you question easier to answer. – Peter Vandivier Jun 10 '20 at 7:10
  • Why don't you ditch the GUI "builder" and run plain SQL statements instead? You should have SQL scripts to do that anyway (and they should be stored in a version control system like git or subversion) – a_horse_with_no_name Jun 10 '20 at 10:33
  • 1
    @a_horse_with_no_name they save some typing an make production quickly. But when they misbehaves like this, they are no longer time and stroke savers but waste! – Stefano Mtangoo Jun 11 '20 at 9:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.