major difference between DELETE DROP TRUNCATE commands

Question

major difference between DELETE DROP TRUNCATE commands ....?

Abhay Shanker · Answer

The DELETE Statement is used to delete rows from a table. synatx:- DELETE FROM employee WHERE id = 1; The DROP command removes a table from the database. All the tables' rows indexes and privileges will also be removed. No DML triggers will be fired. The operation cannot be rolled back. synatx:-DROP TABLE employee ; TRUNCATE removes all rows from a table. The operation cannot be rolled back syntax:-TRUNCATE TABLE employee ; One another difference is DROP and TRUNCATE are DDL commands whereas DELETE is a DML command