From: Date: January 4 2007 3:08pm
Subject: Re: Deleting Foreign Key
List-Archive: http://lists.mysql.com/mysql/204193
Message-Id: <459D0A45.8070502@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Mungbeans,

I do not understand how you get error 152 from the ALTER.

./include/my_base.h:355:#define HA_ERR_ROW_IS_REFERENCED 152

Please print SHOW INNODB STATUS\G after you get that error.

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up 
MyISAM tables
http://www.innodb.com/order.php

.............

From: Mungbeans Date: January 2 2007 12:56am
Subject: Deleting Foreign Key

Get Plain Text

I have a foreign key in a table which I need to drop.  I have successfully
dropped other foreign keys from this table using phpMyAdmin.  However when I
use these commands I get similar error messages:


  ALTER TABLE `mytable` DROP FOREIGN KEY `keyname`
#1025 - Error on rename of '.\database\mytable' to '.\database\#sql2-6ec-11'
(errno: 152)

  ALTER TABLE `mytable` DROP INDEX `keyname`
#1025 - Error on rename of '.\database\#sql-6ec_13' to '.\database\mytable'
(errno: 150)

Any clues as to what I need to do to get rid of this constraint?  I want to
delete the entire table structure and replace it with a different one and
this is the only thing stopping me.