Difference between Delete and Truncate:-

Difference between  Delete and Truncate:-

Truncate:-

1:-Truncate in a DDL operation.

2:-Truncate is faster

3:-Truncate reset the identity column value.

4:-We can’t use condition in truncate.

5:- We can’t rollback in truncate.

Delete:-

1:- Delete is a  DML operation

2:- Delete is slow.

3:-Delete can’t reset identity column value.

4:-We can use condition in delete.

5:-We can rollback in delete.