1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

How do you differentiate between truncate and delete?

Discussion in 'Database' started by aspguy, May 16, 2008.

  1. aspguy

    aspguy New Member

    How do you differentiate between truncate and delete?
  2. shabbir

    shabbir Administrator Staff Member

    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.
  3. Gloria-123

    Gloria-123 New Member

    I even don't get the choice to use the truncate. So when do you use this operation?
  4. skp819

    skp819 New Member

    The Main Difference Between DELETE & TRUNCATE Are :-
    [1] DELETE - is a DML Command & TRUNCATE - is a DDL Command
    [2] After DELETE - can rollback the Records & After TRUNATE - cannot rollback the records
    [3] In DELETE Command you can give the conditions in WHERE Clause & In TRUNCATE you cannot give conditions
    [4] 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

Share This Page