Home Forums SQL Server 7,2000 Administration Identity column RE: Identity column
mccork
SSC-Insane
Points: 22288
More actions
August 6, 2003 at 2:19 am
#468758
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
Cheers,- Mark