title: How to drop primary key which has auto_increment in same column
body: <p>I want to change the column name of a table.</p>
  
  <p>That column name is (ID) and that is primary key and auto_increment column.</p>
  
  <p>I found the query to change the column name is</p>
  
  <pre><code>Alter table mytable change ID, AppID INT(11);
  </code></pre>
  
  <p>But its throwing error, Because of the primary key.
  So i am trying to drop the primary key, But not able to drop primary key also.</p>
  
  <p>How can i drop the primary key which has auto_increment in the same column.</p>
  
  <p>Thanks.</p>