Thread Optionen bei referentieller Integrität
(1 answers)
Opened by wayne95 at 2011-08-25 11:57
Hallo wayne95,
Code: (dl
)
ALTER TABLE tbl_name DROP FOREIGN KEY fk_symbol; Dann: Code: (dl
)
ALTER TABLE tbl_name ADD [CONSTRAINT [symbol]] FOREIGN KEY [index_name] (index_col_name,...) reference_definition; Vgl: http://dev.mysql.com/doc/refman/5.6/en/innodb-fore... und http://dev.mysql.com/doc/refman/5.6/en/alter-table... HTH Grüße payx |