title: How to make a Clustered PK Nonclustered on production DB?
body: <p>I have a clustered PK on what is essentially a log table, which clearly shouldn't be clustered.</p>
  
  <p>When I do:</p>
  
  <pre><code>alter table mytable drop constraint pk_mytable
  </code></pre>
  
  <p>it takes an absolute age on a copy of the DB on my machine (5+ mins) so will invariably not work on the production DB without causing timeouts or timing out itself.</p>
  
  <p>Why isn't this an instant operation? what's it doing?</p>
  
  <p>Is there any way to achieve this without taking my site offline?</p>
  
  <p><strong>Update:</strong> The table has 10s of millions of rows, and several 5? other nonclustered indexes</p>
  
  <p>Thanks</p>