reset a seed value for an identity column

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.