You'll need to 1) rename the table 2) recreate the table specifying IDENTITY for COL1 3) insert data from the original table.

Note also that, to be an IDENTITY, the scale of COL1 must be zero. ie. NUMERIC(p,0)

Cheers,

- Mark