sql resetta rable code example

Example 1: reset identity column in sql server

DBCC CHECKIDENT ('YourTableName', RESEED, 1)

Example 2: sql server 2016 reseed identity

DBCC CHECKIDENT ('[TestTable]', RESEED, 0);
GO