RE: Dropping a foreign key in 4.1.x

- Yogi Berra --- > -Original Message- > From: Joshua Thomas [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 04, 2004 12:33 AM > To: '[EMAIL PROTECTED]' > Subject: Dropping a foreign key in 4.1.x > > > How does one drop a foreign key from a InnoDB tab

Dropping a foreign key in 4.1.x

How does one drop a foreign key from a InnoDB table in mySQL 4.1.x? The manual says "ALTER TABLE yourtablename DROP FOREIGN KEY internally_generated_foreign_key_id You have to use SHOW CREATE TABLE to determine the internally generated foreign key ID when you want to drop a foreign key." Howev