reset identity value truncate

SQL TRUNCATE  TABLE statement is used to delete complete data from an existing table. It is similar to a delete statement without a WHERE clause.