Question: what is the difference between delete truncate and drop command?
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.