Discussion in 'Database' started by aspguy, May 16, 2008.
How do you differentiate between truncate and delete?
DELETE is an operation on a per row basis.
TRUNCATE deallocates data pages which makes TRUNCATE a faster operation to perform over DELETE.
You cannot TRUNCATE a table that has any foreign key constraints. You will have to remove the contraints, TRUNCATE the table, and reapply the contraints.
Also truncate is a DDL command operation.
I even don't get the choice to use the truncate. So when do you use this operation?
The Main Difference Between DELETE & TRUNCATE Are :-
 DELETE - is a DML Command & TRUNCATE - is a DDL Command
 After DELETE - can rollback the Records & After TRUNATE - cannot rollback the records
 In DELETE Command you can give the conditions in WHERE Clause & In TRUNCATE you cannot give conditions
 After using DELETE Command The memory will be occupied till the user does not give ROLLBACK or COMMIT & After using TRUNCATE Command The memory realeased immediately
Separate names with a comma.