title: Drop column not working in MySQL Workbench
body: <p>This is more of a meta-question than I need actual help with but I could not find information about it elsewhere. Today, I tried to delete two tables from a database and upon trying I get the error message that a "foreign key constraint fail" has occurred. No problem, just delete the foreign key as well. So my query looked like the following:</p>
  
  <pre><code>ALTER TABLE Database.mytable
  DROP FOREIGN KEY abc_ibfk_1;
  ALTER TABLE Database.mytable
  DROP COLUMN abc;
  </code></pre>
  
  <p>I get another error message that says "Error Code: 1025. Error on rename of './Database/#sql-461_somerandomnumbers' to './Database/mytable' (errno: 150)"<br/>
  <br/>
  I figure I would use the built-in right-click, drop column in the edit table so I use that and realise it uses a "drop index" as well. So I change my code to look exactly like Workbench would do itself:</p>
  
  <pre><code>ALTER TABLE Database.mytable
  DROP FOREIGN KEY abc_ibfk_1;
  ALTER TABLE Database.mytable
  DROP COLUMN abc, DROP INDEX abc;
  </code></pre>
  
  <p>Now, this is exactly as Workbench would do it, only that when I type it myself it will not execute (above error message) but when I allow Workbench to execute the query it works fine.<br/>
  <br/>
  <br/>
  So, my question is <strong>why is Workbench able to execute the drop query when I can't copy/paste it?</strong></p>