Home > DeveloperSection > Interviews > What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.

Posted on    May-05-2011 12:31 AM

 DB2 DB2 
 1 Answer(s)
  1666  View(s)
Rate this:

Amit Singh

Total Post:565

Posted on    May-05-2011 12:00 AM

Dropping :  (Table structure  + Data are deleted), Invalidates the dependent objects ,Drops the indexes

Truncating:  (Data alone deleted), Performs an automatic commit, Faster than delete

Delete : (Data alone deleted), Doesn’t perform automatic commit


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

Follow MindStick