sql reset identity column values of dynamic table variable code example Example: reset identity column in sql server DBCC CHECKIDENT ('YourTableName', RESEED, 1)