Difference between TRUNCATE and DELETE?
1) Delete is a DML Command while as Truncate is a DDL Command
2) Delete locks table row while as Truncate locks the entire table
3) We can use "where condition" with delete while as we can't user "where
condition" with Truncate
4) DML Trigger fired during the delete while as DML Trigger doesn't fire during the Truncate
5) We can rollback delete operation while as we can't rollback Truncate operation
Delete and Truncate
1) Delete is a DML Command while as Truncate is a DDL Command
2) Delete locks table row while as Truncate locks the entire table
3) We can use "where condition" with delete while as we can't user "where
condition" with Truncate
4) DML Trigger fired during the delete while as DML Trigger doesn't fire during the Truncate
5) We can rollback delete operation while as we can't rollback Truncate operation
0 comments:
Post a Comment