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