Alter column of type timestamp
<p>I want to update an empty table , which has a column of type timestamp to varbinary(8) </p>

<p>I used the following command </p>

<pre><code>ALTER TABLE Notification  ALTER COLUMN RowRevisionID varbinary(8) 
</code></pre>

<p>and I get and an error </p>

<blockquote>
  <p>Cannot alter column 'RowRevisionID' because it is 'timestamp'.</p>
</blockquote>

<p>How can I change a timestamp column type?</p>

<p>I do not wish to drop the column an add a new one , because that will create a column at the end , and I wish to preserve column order to use this table in an INSERT INTO</p>