How does truncate and delete operation effect Identity? Technology Community › Category: SQL › How does truncate and delete operation effect Identity? 0 Vote Up Vote Down VietMX Staff asked 4 years ago Truncate resets the Identity to its base value where as delete does not reset it to the base value.