The difference between drop.delete.trauncat

Delete deletes data, preserves table structure, can roll back, if data volume is large and slow, rollback is due to backup of deleted data (two actions, delete and backup when data is deleted)

Truncate delete all data, keep the table structure, can not roll back, all the data is deleted at one time, the speed is relatively fast (only one action when deleting data: delete)

Drop Delete data and table structure, delete fastest

Between including maximum and minimum values

The difference between drop.delete.trauncat