What are the differences between DELETE, DROP, and TRUNCATE?

Question

Accepted Answer

Delete removes specific rows, Drop removes entire tables, and Truncate clears all rows quickly without logging.

DELETE: Removes specific rows based on a condition. Example: DELETE FROM users WHERE age < 18;
DROP: Completely removes a table or database. Example: DROP TABLE users;
TRUNCATE: Removes all rows from a table but keeps the structure. Example: TRUNCATE TABLE users;

Accepted Answer

DROP and TRUNCATE are DDL command while DELETE is a DML command. DELETE remove the specific row based on the given condition, TRUNCATE removes all the record from the table at once, whereas the DROP command removes the table or databases and as well as the structure.

Accepted Answer

DELETE: Removes specific rows from a table based on a condition.
TRUNCATE: Removes all rows from a table, resetting identity columns, but retains the table structure.
DROP: Removes an entire table or database, including its structure.

Accepted Answer

Delete is a dml.and truncate or drop is ddl.the delete data can be rollback. Truncate can not be rollback .and drop can not be rollback .the delete are used to delete one row and all based on where condition and can not delete the schema .and truncate are delete all row and can not delete the schema .and drop is used to all row delete with schema

Accepted Answer

TRUNCATE deletes all the rows from the table,

DROP deletes entire table permanently, and

DELETE deletes one or more records from the existing table.

Asked in TCS and 33 others

What are the differences between DELETE, DROP, and TRUNCATE?

Interview Questions from Popular Companies