T-SQL – How to reset auto increment to next available number
The following T-SQL shows how to reset a tables identity auto increment back the last available number. This may be useful if you have removed a bulk amount of data…
CHECKIDENT
T-SQL – How to reset auto increment to 1
The following T-SQL shows how to reset a tables identity auto increment back to 1. This may be useful if you have cleared all data from a table and want…