Question: what is the difference between delete drop and truncate in sql?
Answer: The DROP command removes a table from the database. All the tables' rows, indexes and privileges will also be removed. ... 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.