title: Unable to DROP a MySQL Table
body: <p>I need to drop a deprecated, empty table from my MySQL Database.</p>
  
  <p>The table definition is noddy:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `Address` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ContactId` int(11) NOT NULL,
    PRIMARY KEY (`Id`),
    KEY `ContactId` (`ContactId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  </code></pre>
  
  <p>This results in </p>
  
  <p><code>#1217 - Cannot delete or update a parent row: a foreign key constraint fails</code></p>
  
  <p>There was a constraint on ContactId but II've removed it.</p>
  
  <p>PHPMyAdmin's export function doesn't show anything beyond the table definition shown above. There are no rows in the table and, to my knowledge, no FKs reference the <code>Address.Id</code> field (But I don't know how to verify this).</p>
  
  <p>Can someone please advise how I can get rid of the table?</p>