Daily Tip: Starting a table over again.
Posted in Database, Tip on July 16th, 2004 by Tony – Be the first to commentIf you want to clear out a table in M$ SQL so that the key starts back over at 1, use TRUNCATE instead of DELETE FROM in your query
TRUNCATE TABLE is functionally identical to DELETE statement with no WHERE clause: both remove all rows in the table. But TRUNCATE TABLE is faster and uses fewer system and transaction log resources than DELETE.