| Truncate | Delete |
|---|---|
| This is a DDL(Data Defination Language) command | This is a DML(Data Manipulation Language) command |
| This will delete the entire table | This can delete the entire table or can be rows. |
| Where clause is not applied | Where clause can be applied |
| This will reset the seed value | This will not reset the seed values which means identity of the column will remain same. |
| Performance wise is faster | This is slower than Truncate |
| We cannot rollback the changes. | We can rollback the changes. |
Sunday, February 28, 2021
Difference between Truncate and Delete
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment