Question { 6108 }

difference between truncate and delete ,drop?

Answer

Drop deletes the table along with its structure from the database.
Delete command deletes the records from the table and it also deletes the table space allocated in the database.

Truncate is similar to Delete but it does not delete the table space from the database.

Drop and Truncate are the DDL command hence can't be rolled back whereas Delete is a DML command and can be rolled back.