Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

A table has been created, but I realize I need a new column - RecordID (this column automatically assigns numerical value to each row of record) What would I have to do in SQL management studio to accomplish that? Thank you!

share|improve this question

1 Answer 1

Create a new table with an autonumber field, then copy the data from your original table to the new one. Once that is done, remove the original table, and rename the new one with the name of the original.

share|improve this answer
is there a command for copying? –  user34683 Mar 15 '11 at 23:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.