Difference between Delete and Truncate?
Posted by Marcus in SQL Server on Jul 05, 2011
  • 0
  • 4
  • 6607
Do you know the answer for this question? Post it below.
Posted by Shankar M on Dec 13, 2012
  • 0

Delete and Truncate does the job of removing the rows from the Table. The difference lies in the fact that, When we issue a delete command we can rollback the statement issued, where as in Truncate rollback cannot be issued.

Posted by vidya bollineni on Aug 16, 2011
  • 0

<P>Delete: By using Delete we can delete particular rows..through Where condition</P> <P>eg.&nbsp; delete from emp where age=10</P> <P>Drop: if we want to delete the whole table...i.e...table structure,attributes,indexes..every thing we use drop</P> <P>eg. drop table emp</P> <P>Truncate:if we only want to get rid of the data inside the table and not the table itself we use truncate</P> <P>eg.truncate table emp</P>

Posted by RMS on Jul 23, 2011
  • 0

DELETE Statement: This command deletes only the rows from the table based on the condition given in the where clause or deletes all the rows from the table if no condition is specified. But it does not free the space containing the table. <P>TRUNCATE statement<STRONG>:</STRONG> This command is used to delete all the rows from the table and free the space containing the table.</P>

Posted by nagabhushan Hiremath on Jul 06, 2011
  • 0

<P>Delete : Delete is DML Command it mean once you delete the containts from table you can revert back.</P> <P>Truncate: it is DDL command it mean once you delete the containts from the table you can't roll back.</P>

C# Corner Hyderabad Developer Conference

Most Popular Companies

Most Popular Job Functions