Difference between delete and truncate commands in sql
Hi friends,In this article i would like to explain delete and trncate commands.
Delete:
a) It is DML command and speed is slow.
b) Remove rows one by one and we can use where clause
c) we can rollback and fires trigger.
Truncate:
a) It is DDL command and speed is faster.
b) Remove all rows in one execution and we can't use where clause.
c) We can't rollback and does't fire trigger.
Read More Add your Comment