title: Why I can't drop foreign key using foreign key name but instead it accepts something like works_with_ibfk_2 type name?
body: <pre><code>CREATE TABLE client (
    client_id INT PRIMARY KEY,
    client_name VARCHAR(40),
    branch_id INT,
    FOREIGN KEY(branch_id) REFERENCES branch(branch_id) ON DELETE SET NULL
  );
  
  CREATE TABLE works_with (
    emp_id INT,
    client_id INT,
    total_sales INT,
    PRIMARY KEY(emp_id, client_id),
    FOREIGN KEY(client_id) REFERENCES client(client_id) ON DELETE CASCADE,
    FOREIGN KEY(emp_id) REFERENCES employee(emp_id) ON DELETE CASCADE
   );
  </code></pre>
  
  <pre><code>drop table client;
  </code></pre>
  
  <blockquote>
    <p>Cannot drop table 'client' referenced by a foreign key constraint
    'works_with_ibfk_2' on table 'works_with'.</p>
  </blockquote>
  
  <pre><code>alter table works_with drop foreign key client_id;
  </code></pre>
  
  <p>I'm getting this</p>
  
  <blockquote>
    <p>Can't DROP 'client_id'; check that column/key exists</p>
  </blockquote>