The difference between TRUNCATE, DELETE, and DROP is one of the most common interview questions. Here are some of the common differences between them.
Difference Between TRUNCATE, DELETE In SQL
| DELETE | TRUNCATE |
| Delete row by row values | Truncate entire data from the table at one shot |
| Delete can have where condition | Truncate we cannot apply where condition |
| Roll back is possible | Roll back is not possible |
| Slow operation | Very fast operation |
| DML Operation | DDL operation |
| if we delete only data gets deleted | If we truncate only data gets deleted but structure remains same |
| Delete Operation will not reset seed value of identify column | Truncate resets the seed value |