Clear ID counter after delete data table

2011-01-28


If you have auto increase ID column in your SQL Server table, and if you want to clear the automatically counter:

TRUNCATE TABLE xxx