title: Adding an identity column / primary key to an existing table in SQL Azure
body: <p>If you alter a SQL Azure table to add an identity column as primary key, does that create a new table and drop the original table?</p>
  <p>I have a very large table and limited space. I am concerned that if I add the identity column (as PK) to this table, it will be be dropped and recreated, thus doubling the size of my database.</p>
  <p>I have read that adding a column is just a metadata change but I am not sure about an identity and primary key column. I have read that reseeding an identity property will cause a table to be dropped and recreated but I am not sure that if adding an identity column performs the same operation as reseeding because it is adding a column.</p>