Only Defaults Constraint Names

[peterlaursen]

when creating a foreign key with SQLyog it excecutes this statement:

alter table `test4`.`child` add foreign key (id2) references `parent` (id2);

this will in this case genereate a default constraint name “child_ibfk_1”

A better syntax to use would be

alter table `test4`.`child` add Constraint foreign key (id) references `parent` (id);

… where the user should have an option to enter the .

I also experience what when rather long fieldnames are used for FK's the relations manager simply is not wide enough to show things. And line is not wrapped, so last part of the definition is not visible.

I think a fix for this should not wait to 5.0 or whenever the new relations manager is planned for.

[Ritesh]

I guess its high time to make all the dialog boxes resizable.

We will add an option in v4.2 where you can specify the constraint name.

[peterlaursen]

Thx 😀

Actually I think that the ODBC-import should have an option too, where users could enter the constraintname.

A possible way to do it would be to have a button “edit constraints” close to the FK checkbox (see attached) throwing up the SQL. From here you would be able to change the constraintname and even choose only SOME and not ALL of the FK's to be imported.

I know that support for constraintname must be implemented in SJA-code and the XML-schema too. How complicated that would be I don't know!

[Author]

Posts