What is the difference between delete , truncate and drop?

Question

Accepted Answer

Delete removes specific rows from a table, truncate removes all rows, and drop removes the entire table.

Delete is a DML operation, while truncate and drop are DDL operations.
Delete is slower as it logs individual row deletions, while truncate and drop are faster.
Delete can be rolled back, while truncate and drop cannot be rolled back.
Delete can have conditions to specify which rows to delete, while truncate and drop affect the entire table.
Example: DELETE FROM table_name WHERE condition;
Example: TRUNCATE TABLE table_name;
Example: DROP TABLE table_name;

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

The DELETE command deletes one or more existing records from the table in the database.
The DROP Command drops the complete table from the database.
The TRUNCATE Command deletes all the rows from the existing table, leaving the row with the column names.

What is the difference between delete , truncate and drop?

Top TCS Informatica ETL Developer interview questions & answers

Popular interview questions of Informatica ETL Developer