What is the difference between DELETE, TRUNCATE, and DROP?medium
Answer
DELETE removes rows, TRUNCATE clears all rows, and DROP removes the table.
Explanation
DELETE can filter rows and often logs row changes. TRUNCATE is faster for clearing a table. DROP removes the schema object and data.
Follow-upWhich operations can be rolled back in your database?