title: Disable Primary Key and Re-Enable After SQL Bulk Insert
body: <p>I am about to run a massive data insert into my DB.  I have managed to work out how to enable and rebuild non-clustered indexes on my tables but I also want to disable/enable primary keys as I believe this will speed up the insertion process.</p>
  
  <p><strong>NOTE:</strong> This is over numerous tables and so I assume I need some loop to get the primary key information and run the following to drop it but I'm not sure about recreating it:</p>
  
  <pre><code>ALTER TABLE Table1
  DROP CONSTRAINT PK_Table1_Col1
  </code></pre>