Reset auto number | Varinder Sandhu

SQL Server – Reset auto number (IDENTITY) column in SQL Server

Varinder Sandhu SQL, SQL-Advanced, SQL-General, SQL-Query, SQL-Scripts, Varinder Sandhu

How to reset auto number (IDENTITY) column in SQL Server? Sometimes we need to reset the auto number – identity column in a table. Using the DELETE statement is not enough. The statement only deletes the data but not reset the identity column. We can reset the auto number (IDENTITY)

» Read more

DBCC CHECKIDENT, Reset auto number, Reset IDENTITY column