1. DELETE: Removes rows from a table.

DELETE FROM table_name
WHERE condition;

-- like, id_number = 7, it will delete the row which id no=7

1. TRUNCATE: It is used to delete all rows from a table.

TRUNCATE TABLE table_name;

1. DROP: Deletes a table or database.

DROP TABLE table_name;

Questions:

Q. What is the difference between DELETE and TRUNCATE and DROP statements?

Ans:

DELETE removes specific or all rows and can use a WHERE clause | Slow | Rolled back easily.

TRUNCATE removes all rows without using WHERE | Fast | Can’t Rolled Back.

DROP removes a table or database completely | Fast | Can’t Rolled Back.