Clear ID counter after delete data table

Published on Friday, January 28, 2011
sql

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

TRUNCATE TABLE xxx