Difference between Truncate , delete and drop

Question

Accepted Answer

Truncate, delete, and drop are SQL commands used to remove data from a database, but they differ in their functionality.

Truncate is a DDL command that removes all rows from a table, but keeps the structure intact.
Delete is a DML command that removes specific rows from a table based on a condition.
Drop is a DDL command that removes an entire table from the database, including its structure and data.
Truncate is faster than delete as it doesn't generate any transaction logs.
Delete can be rolled back, but truncate and drop cannot be rolled back.
Examples: Truncate table employees; Delete from customers where age > 50; Drop table orders;

Popular interview questions of ETL Test Engineer