RI用のテーブル名は元テーブル名の28字まででござるの巻

CREATE TABLE AAAAAAAAAABBBBBBBBBBCCCCCCCCCC (
COL1 CHAR(2) CHARACTER SET LATIN PRIMARY KEY
)
;
ALTER TABLE  AAAAAAAAAABBBBBBBBBBCCCCCCCCCC
 ADD CONSTRAINT FOO FOREIGN KEY (COL1) REFERENCES HOGE(FUGA)
;

> AAAAAAAAAABBBBBBBBBBCCCCCCCC_0テーブルができる

CREATE TABLE AAAAAAAAAABBBBBBBBBBCCCCCCCCCD (
COL1 CHAR(2) CHARACTER SET LATIN NOT NULL PRIMARY KEY
)
;
ALTER TABLE  AAAAAAAAAABBBBBBBBBBCCCCCCCCCD
 ADD CONSTRAINT BAR FOREIGN KEY (COL1) REFERENCES HOGE(FUGA)
;

> 5303:  Error table 'user_name.AAAAAAAAAABBBBBBBBBBCCCCCCCC_0' already exists.