Difference between Dropping,Truncating and Delete Operation in Database

Posted On: 2023-03-26 15:40:48 Database

Dropping
(Table Structure+Data are deleted ) Invalidate the dependent object,Drop the table index

Truncating
(Data Alone Deleted) perform Auto Commit, Faster then delete

Delete
(Data Alone Deleted) Does not perform Auto Commit