WHAT IS THE DIFFERENCE AMONG "DROPPING A TABLE", "TRUNCATING A TABLE" AND "DELETING ALL RECORDS" FROM A TABLE.

Amit Singh

Total Post:565

Points:2825
Posted by  Amit Singh
DB2 
DB2
 1712  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:565

    Points:2825
    What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.

    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

                                         

Answer

NEWSLETTER

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