title: Drop and recreate primary key
body: <p>I want to change a primary key/index on a database table to change the index option <code>ignore_dup_key</code> to 'on'.</p>
  
  <p>According to this question " <a href="https://stackoverflow.com/questions/2594193/can-i-set-ignore-dup-key-on-for-a-primary-key">Can I set ignore_dup_key on for a primary key?</a> " I need to drop the index and create a new one.</p>
  
  <p>Before I drop the index, how can I get the command to recreate it? Then I'll just change the <code>ignore_dup_key</code> option.</p>