SQL TRUNCATE

If you want to clear out a table in MS SQL that includes an identity field AND want to reset the field so it starts over at 1, use TRUNCATE instead of DELETE FROM.