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

Last updated:9/16/2020 10:10:36 PM

1 Answers

Amit Singh
Amit Singh

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