delete reset identity value

SQL delete statement is used to delete records from table based on specific conditions which are passed in where clause.