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!
| |||
|
feedback
|
|
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. | |||
|
feedback
|
