Wimmeke
asked on
Small Identity and PK script
Hi guys,
I've got a table in which I have two columns, ID and URL. I would like to have a script which can set the ID column to be the PK and enable an identity starting from 1 increasing with 1.
NOTE: The table already contains 5000 records which I don't want to loose.
Can anyone help me with this?
Thanks!
Wim Toremans
I've got a table in which I have two columns, ID and URL. I would like to have a script which can set the ID column to be the PK and enable an identity starting from 1 increasing with 1.
NOTE: The table already contains 5000 records which I don't want to loose.
Can anyone help me with this?
Thanks!
Wim Toremans
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I assume the ID column already has values in - do you want to keep those ID values?