Hi all,

I have a table, to which I add a column:

alter table temp.dbo.tmpdumpallprs
add dumpprsid bigint IDENTITY(1,1) NOT NULL

So the column is filled with values 1 to {nr of records}. Now I want to add a constant to the column. So I have to remove the identity property. How do I do that?