How to reset autoincrement integer field

autoincrement columns are columns that automatically increment the integer value of that column for every new row created. The step below will reset the next number to the specified value USE <databasename> dbcc checkident (<tablename>,reseed,1);