What is the difference between delete,drop and truncate?

Drop deletes the table and its structure from the data base. It cannot be rolled back
Truncate will also delete the records but it will not delete the table space which is created by the data base. It cannot be rolled back




Delete command used for deleting the records from the table, and it removes the table space which is allocated by the data base. It can be rolled back