Ankur Jain
What is the difference between DELETE and TRUNCATE statement?
By Ankur Jain in SQL Server on Aug 18 2014
  • Sreekanth Reddy
    Jul, 2015 11

    Truncate: Frees the space of table after executing. Delete: It will not frees the space of table.

    • 0
  • Ankur Jain
    Aug, 2014 18

    A DELETE statement enables you to selectively remove data from a table, whereas The TRUNCATE statement unconditionally removes all rows from a table.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS