SQL Server adds attributes (auto-increment) to tables that have been created

When you create this table, set the ID to type int, and then set the identity to Yes and the seed to 1 increments.
If this table is already built, you can add a field called ID at the end, and then do the same as above, then save to add. (Be sure to set it up after saving)

ALTER TABLE student Add ID int identity (up to)

After saving a new column ID, in the table design to delete the primary key, the ID moved to the first column location, the ID is set as the main key.

Note: The identity is best used when all the data is created and last added, otherwise the serial number is not changed and memory is consumed.

SQL Server adds attributes (auto-increment) to tables that have been created