What Is The Difference Between Truncate And Delete Commands?

1.	What Is The Difference Between Truncate And Delete Commands?
Answer» Both will RESULT in deleting all the ROWS in the table .TRUNCATE call cannot be ROLLED back as it is a DDL command and all memory space for that table is released back to the server. TRUNCATE is much faster.Whereas DELETE call is an DML command and can be rolled back. Both will result in deleting all the rows in the table .TRUNCATE call cannot be rolled back as it is a DDL command and all memory space for that table is released back to the server. TRUNCATE is much faster.Whereas DELETE call is an DML command and can be rolled back.

Answer»

Both will RESULT in deleting all the ROWS in the table .TRUNCATE call cannot be ROLLED back as it is a DDL command and all memory space for that table is released back to the server. TRUNCATE is much faster.Whereas DELETE call is an DML command and can be rolled back.

Both will result in deleting all the rows in the table .TRUNCATE call cannot be rolled back as it is a DDL command and all memory space for that table is released back to the server. TRUNCATE is much faster.Whereas DELETE call is an DML command and can be rolled back.

Discussion

No Comment Found

Related InterviewSolutions

What's The Maximum Size Of A Row?
What Type Of Index Will Get Created After Executing The Below Statement?
What Are Defaults? Is There A Column To Which A Default Can't Be Bound?
What Is Group By?
What Is A Sql View?
Why Can A "group By" Or "order By" Clause Be Expensive To Process?
What Types Of Index Data Structures Can You Have?
What Is A "constraint"?
What Is "normalization"? "denormalization"? Why Do You Sometimes Want To Denormalize?
What Are The Tradeoffs With Having Indexes?