Question: what is the difference between delete drop and truncate?
Answer: TRUNCATE removes all rows from a table. The operation cannot be rolled back and no triggers will be fired. As such, TRUNCATE is faster and doesn't use as much undo space as a DELETE. The DROP command removes a table from the database.