interview

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

Ask Question

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

Amit Singh314805-May-2011
db2db2 
Updated on 16-Sep-2020
Amit Singh

Amit Singh

Follow

Can you answer this question?

Answer

1 Answers

Amit Singh

Amit Singh

05-May-2011
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

                                     

Liked By