Moderate
Difference between DELETE and TRUNCATE statements and effect on ID
Filed under Hexaware
The question
Explain the difference between SQL DELETE and TRUNCATE statements, what the IDENTITY attribute is, and what happens to the auto-incremented ID in both operations.
No write-up yet. Related questions below have one.
Related Hexaware questions
Collected from public candidate posts and coding forums. Updated Nov 2026.