Home > DeveloperSection > Interviews > what is different between delete and truncate

Posted on    September-28-2015 3:46 AM

 Database SQL 
Ratings:
 1 Answer(s)
  582  View(s)
Rate this:

shailesh tiwari
shailesh tiwari

Total Post:2

Points:10
Posted on    September-28-2015 3:46 AM

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

Don't want to miss updates? Please click the below button!

Follow MindStick