Question

What is the difference between DELETE, TRUNCATE, and DROP commands in SQL?

Q: Answer-What is the difference between DELETE, TRUNCATE, and DROP commands in SQL?

DELETE is DML removes rows matching a WHERE clause, fires row-level triggers, logs each deletion, and can be rolled back within a transaction. TRUNCATE is DDL removes ALL rows instantly by deallocating data pages, cannot be rolled back in most RDBMS, does not fire row triggers, resets identityauto-increment counters. DROP removes the table schema entirely structure, data, indexes, triggers are all permanently gone. Critical distinction for banking database administration.