CodingForums.com - View Single Post

Old Pedant · 11-08-2012, 10:21 PM

There's no "ALTER CONSTRAINT" command, so you just have to do:

Code:

ALTER TABLE DROP FOREIGN KEY nameyougaveit;

ALTER TABLE ADD CONSTRAINT FOREIGN KEY name ...same as in create...

11-08-2012, 10:21 PM	PM User \| #25
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,185 Thanks: 59 Thanked 3,995 Times in 3,964 Posts	There's no "ALTER CONSTRAINT" command, so you just have to do: Code: ALTER TABLE DROP FOREIGN KEY nameyougaveit; ALTER TABLE ADD CONSTRAINT FOREIGN KEY name ...same as in create... Simple, really. This, too, is documented: http://dev.mysql.com/doc/refman/5.5/en/alter-table.html __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.