title: Alter table to set the IDENTITY to off
body: <p>I have a table, which has a column(orderid), which its IDENTITY is set to true. Now I would like to set it off.  How can I do that with ALTER COLUMN?some thing like this?</p>
  
  <pre><code>ALTER TABLE MyTable
  ALTER Column MyColumn SET IDENTITY OFF
  </code></pre>