title: MySQL Drop foreign key Error 152
body: <p>I am trying to drop a number of foreign keys using:</p>
  
  <pre><code>ALTER TABLE `table` DROP FOREIGN KEY `fk_table_users1` , DROP FOREIGN KEY `fk_table_accounts1` , DROP FOREIGN KEY `fk_table_data1` ;
  </code></pre>
  
  <p>but it returns the error:</p>
  
  <pre><code>Error on rename of './db/table' to './db/#sql2-179c-288289' (errno: 152)
  </code></pre>
  
  <p>I have run <code>SHOW ENGINE INNODB STATUS</code> which says:</p>
  
  <pre><code>120725 12:38:37 Error in dropping of a foreign key constraint of table db/table,
  in SQL command
  ALTER TABLE `table` DROP FOREIGN KEY `fk_table_users1` , DROP FOREIGN KEY `fk_table_accounts1` , DROP FOREIGN KEY `fk_table_data1` 
  Cannot find a constraint with the given id fk_table_users1.
  </code></pre>
  
  <p><code>SHOW CREATE TABLE 'table'</code> output:</p>
  
  <pre><code>CREATE TABLE `table` (
   `id` int(11) NOT NULL auto_increment,
   `data_id` int(11) NOT NULL,
   `account_id` int(11) NOT NULL,
   `status` enum('pending','complete') NOT NULL default 'pending',
   `created_at` datetime NOT NULL,
   `created_by` int(11) NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `fk_orders_users1` (`created_by`),
   KEY `fk_orders_data1` (`data_id`),
   KEY `fk_orders_accounts1` (`account_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  </code></pre>
  
  <p>However when I look at the structure via phpmyadmin it lists the foreign key with the same name. Do I need to do something else before I can drop the foreign keys?</p>