WHAT IS DIFFERENT BETWEEN DELETE AND TRUNCATE

shailesh tiwari

Total Post:2

Points:10
Posted by  shailesh tiwari
SQL 
 933  View(s)
Ratings:
Rate this:
  1. shailesh tiwari

    Post:2

    Points:10
    what is different between delete and truncate

    delete command deletes the data which can be restore by usin commit or rollback command.

    Truncate deletes permanently data which can not be restore

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!