- 1). Click the Windows "Start" button and then click "All Programs." Click "SQL Server" to open the program group and then click "SQL Server Management Studio" to open your software.
- 2). Click the database that contains the table you wish to edit. Click "Tables" in the list of expanded options; all your tables are displayed. Right-click the table that you want to edit and select "Modify."
- 3). Click the column that you wish to use as a sequence number. If you want to create a new column for the sequence number, type a name for the column in the next available text box in the list of column names.
- 4). Scroll down the list of properties until you reach the property labeled "Identity Specification." Click the plus sign next to this option to display more options. In the drop-down labeled "Is Identity," choose "Yes."
- 5). Click "Save" in the main Management Studio toolbar. Your sequence-number column is created and saved to the table.
Source...