Interviews - C# Corner

What is the difference between TRUNCATE and DELETE commands?
By Pradeep in SQL Server on Aug 20 2009
  • Priyadarshi  Datta
    Oct, 2009 30

    Delete&nbsp; is DML command&nbsp; used to delete rows from a table. A where clause can be used to remove some&nbsp; rows.If no where clause is specified all rows will be removed.After delete operation you need to commit or Rollback the transaction to make the transaction permanent or to undo it.<br><br>On the other hand Truncate is a DDL Command remove all rows from the table.The operation cannot be rolled back.As such truncate is faster and does not use as much undo space as delete.<br><input id="gwProxy" type="hidden"><!--Session data--><input onclick="jsCall();" id="jsProxy" type="hidden"><div id="refHTML"></div>

    • 0
  • f k
    Sep, 2009 7

    <P>delete is DML cmd so we hav to save after delete i.e. no autosave</P> <P>truncate is DDL cmd so autosave</P> <P>&nbsp;</P> <P>and truncate is faster than delete </P> <P>bcoz delete cmd deletes rows one by one&nbsp;</P>

    • 0
  • Juan Lago
    Aug, 2009 23

    <P>Truncate is faster than delete because the Delete command deletes the records row by row</P> <P>and command truncate delete all at once</P>

    • 0

Most Popular Companies

Most Popular Job Functions