Dear Experts,

How use SQL scripts to change an existing column to become an Identity
column (auto increment) ??
eg. Current column : ID1 BigInt --> ID1 BigInt Identity(1,1)

I want back the values of the existing column after change to identity
column.

Is there any other way instead of create a Temp table, move data over,
drop an existing table and re-create back the table, and move back the
data ??

Thanks.

Regards,
Chen Fock Siong
08-Jun-2004