Question: what is the difference between delete truncate and drop statements in sql?
Answer: 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. ... DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.