No way to choose how foreign key names that are generated

Acs's profile image Acs posted 9 years ago in General Permalink
Hey,

Would it be possible to add an option to configure how the foreign key names are created?

I know I can change this but it is still annoying when you are creating lots of foreign keys in lots of tables.

The default seems to be:

FK_<table>_<reference_table>

So if we could have something in the "Preferences" dialog where we could change this format with the following placeholders:

{table}
{reference_table}
{column}
{foreign_column}

So imagine we have an edit box and the user could do something like this:

fk_{column}

Heidi would just use this and create the foreign key name.

Thanks!
Acs's profile image Acs posted 9 years ago Permalink
There is no way to edit this so...

One more thing you could add is something like this but for the INDEX.
So instead of the same name the user could edit and give a custom format for the index.
ansgar's profile image ansgar posted 9 years ago Permalink
This is just the predefined name. You can edit that name as you want, at any point. HeidiSQL just generates that name automatically as long as you haven't yet edited it. Isn't the preferences dialog overcrowded already with things?
Acs's profile image Acs posted 9 years ago Permalink
If it has useful things I don't think anybody would mind.

I ask for this because in my company there is a business requirement that the foreign key names and index follow certain standards. I was just hoping the heidiSQL would make my life easier regarding this.

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