ask how to reset identity to 1 after deleting all rows

Accepted answer

please use Truncate, it will rest all

+3

Hi,

let suppose table name is Emp

// deleting all row

DELETE FROM Emp;

commit;

// reset the identity

DBCC CHECKIDENT ('Emp', RESEED, 0)

+1

The below two statements

DELETE FROM [MyTable];

DBCC CHECKIDENT ('[MyTable]', RESEED, 0);

is equivalent to

TRUNCATE TABLE [MyTable];

+1

Hi Suhel Jamadar,

Use the Truncate statement, as the truncate statement will reset the identity value to the original seed value of the table

I hope this will help you.

+2