Difference Between Delete,Truncate and Drop

Delete :

• Delete is a DML command.
• Delete command uses undo table space for roll back.
• deletes can be undo by using Rollback.
• Delete command can be used to delete few rows from table or all rows from table.
• After the Delete command need to use the  Commit or Rollback command to permanent the transaction.

Truncate ;

• Truncate is a DDL command.
• Truncate removes all rows from a table.
• truncate wont use any table space and triggers will be filred.
• It cannot be Rolled Back.
• It's faster than Delete.

Drop :

• Drop removes the data and the table structure from the Database.
• Operation cannot be rolled back.
• No DML trigger will be fired.