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

Question

Amit Singh · Answer

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

interview

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

Amit Singh

Can you answer this question?

1 Answers

Liked By