An Identity column in SQL Server is used to auto number the rows. See this great post on Autonumbering & Identity Columns. When you delete rows from the table, the identity will not reset but you have few options of doing it yourself. The SQL Server Management Studio GUI doesn’t support this option…
1. DBCC CHECKIDENT
This [...]