Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Easier way to create foreign keys

Acs's profile image Acs posted 6 years ago in Feature discussion Permalink
Hey,

So right now the only way to create foreign keys is to go to the Foreign keys tab and do it there.
I suggest an alternative.
In the menu that appears when you right click the fields (in the Table: <table name> tab) there should be an option to create a foreign key. The way this would work would be:

User clicks with the right button on a field

- User goes to the Menu "Create Foreign Key" where a menu is presented with all the available tables (heidi is already showing the tables on the treeview so this can be cached somewhere).

- User navigates to the table he/she wants.

- Another menu is presented with that tables fields.

- The field the user selects is the field he/she wants to make the foreign key link to.

This way you can make a foreign key right in the field list and not have to navigate to the foreign keys.
Heidi already has something similar for the primary key where you can just right click a field and select it to be the primary key, why not make something similar to the foreign keys.

Thanks!

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.