How to Create an Autoincrement Number SQL Express Server
- 1). Open SQL Server Management Studio Express.
- 2). Connect to the SQL Server Express Engine.
- 3). Expand the server entry.
- 4). Expand the "Databases" folder.
- 5). Expand the database you wish to work in.
- 6). Expand the "Tables" folder.
- 7). Right-click on the table you wish to work with and, in the pop-up menu, click on "Design." This will open a panel showing the table chosen with the current fields within the table.
- 8). Select the column name you wish to have as an auto-increment column and left click on it. Please not that this column must be a numeric data type column.
- 9). Locate the entry, in the column properties tab, labeled "Identity Specification" and expand the entry.
- 10
Change the value of the "(Is Identity)" item to "Yes." - 11
Change the "Identity Increment" to the number you wish to increment by. - 12
Change the "Identity Seed" to the number you wish to begin incrementing from. - 13
Close the window pane containing the table design screen and save the table.
Source...