How do the commands DROP, TRUNCATE, and DELETE differ in SQL?

Answer»

DROP	TRUNCATE	DELETE
DROP is USED for deleting a database, table, or a view	TRUNCATE is used for deleting all ROWS of a table	DELETE can either delete all of the rows at once or ONE by one. i.e., we can use it according to our needs.
No data can be rollbacked	No data can be rollbacked	Data can be rollbacked
It is a Data Definition Language (DDL) command	It is a Data Definition Language (DDL) command	It is a Data Manipulation Language (DML) command.
It deletes the entire structure of the table.	It PRESERVES the structure of the table.	It does not affect the structure of the table.

Discussion