title: Add a column to specific position in MSSQL Server
body: <pre><code>ALTER TABLE Log ADD log_id bigint IDENTITY BEFORE cust_id_fk
  </code></pre>
  
  <p>The above code adds a new column to last position. I want it to be added to the first position. Also I want to make it as Primary Key.</p>