Hello Heikki,
> >
> >> you have to use a fairly recent 4.0 or 4.1 version of MySQL.
> >
> >Does a newer version allow you to change/set the names yourself?
>
> you can give the name yourself in new versions. Please look at the InnoDB
> manual section.
"A constraint name can be given as of MySQL 4.0.18"
Ah, by itself - a great feature. Pain in the *** though, that it has been
added in (yet another) _minor_ MySQL update. This makes providing
tools for it quite a burden...
The good thing: this is an addition, unlike renaming a column returned
from SHOW TABLES :-/
Thanks for pointing this out.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
