Thread Optionen bei referentieller Integrität (1 answers)
Opened by wayne95 at 2011-08-25 11:57

payx
 2011-08-25 13:14
#151792 #151792
User since
2006-05-04
564 Artikel
BenutzerIn

user image
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

View full thread Optionen bei referentieller Integrität