Question: what is the difference between delete truncate and drop in sql?
Answer: To remove specific rows, use DELETE . To remove all rows from a large table and leave the table structure, use TRUNCATE TABLE . It's faster than DELETE . To remove an entire table, including its structure and data, use DROP TABLE .