SQL AUTO INCREMENT a Field - W3Schools

Very often we would like the value of the primary key field to be created automatically every ... We would like to create an auto-increment field in a table. ... The MS SQL Server uses the IDENTITY keyword to perform an auto-increment feature.

www.w3schools.com