Hi, Jan! > How you would detect the difference between no object name given and > object name given, remember that InnoDB does not store the key > identifier (a and b above). Thus the actual foreign key name is > similar to one generated when no key identifier is not given ? > E.g: > > alter table t2 add foreign key if not exists (id) references t1 (id); > alter table t2 add foreign key if not exists a(id) references t1(id); > alter table t2 add foreign key if not exists b(id) references t1(id); > > For InnoDB point of view there are all similar foreign keys but all have > different object name and all actual names are generated > on the engine.
Hmm. I didn't know that, I thought InnoDB only generates a name when no was explicitly given by the user. What names will be shown in SHOW CREATE TABLE and various I_S tables? I mean, "a" and "b" or generated ones? Regards, Sergei _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
