Disable default order by label on foreign keys

dario's profile image dario posted 6 years ago in General Permalink

Hi, is it possible to disable default column ordering by label, or choose another one when selecting from foreign keys dropdown, as you can see in picture below?

Thanks in advance.

1 attachment(s):
  • examples
ansgar's profile image ansgar posted 6 years ago Permalink

No, this is hardcoded. HeidiSQL searches for the first text/varchar column in the target table and uses that for displaying.

dario's profile image dario posted 6 years ago Permalink

Thank you very much for the quick reply. But if the first varchar column is a PK/Unique, HeidiSQL will search for the next one, is it correct? Best regards

ansgar's profile image ansgar posted 6 years ago Permalink

Now that I look into the relevant code again, I see that it's the first text column, which is not the foreign key column itself. This can also be a primary key, but not necessarily.

dario's profile image dario posted 6 years ago Permalink

Ok, now is all clear, thanks for your support!

Please login to leave a reply, or register at first.