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

Question

Amit Singh · Answer

Dropping : (Table structure + Data are deleted), Invalidates the dependent objects ,Drops the indexesTruncating: (Data alone deleted), Performs an automatic commit, Faster than delete Delete : (Data alone deleted), Doesn’t perform automatic commit

interview

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

Can you answer this question?

1 Answers