Difference between DELETE DROP and TRUNCATE
TRUNCATE: It removes ALL rows from a table by de-allocating the memory pages, This operation cannot be rolled back.
DELETE: This command removes some or all rows from a table based on the condition, This operation can be rolled back.
DROP: This command removes a table from the database completely.