Difference between DELETE, DROP, and TRUNCATE command in SQL Server

Опубликовано: 24 Сентябрь 2021
на канале: Towards Data Analytics

1,304

DELETE:
DELETE is a Data Manipulation Language Command (DML). It is used to delete one or more tuples of a table. With the help of the “DELETE” command, we can either delete all the rows in one go or can delete rows one by one. i.e., we can use it as per the requirement or the condition using the Where clause. It is comparatively slower than TRUNCATE cmd.
DELETE FROM TABLE;

DROP:
It is a Data Definition Language Command (DDL). It is used to drop the whole table. With the help of the “DROP” command, we can drop (delete) the whole structure in one go i.e. it removes the named elements of the schema. By using this command the existence of the whole table is finished or say lost.
DROP TABLE TABLE NAME;

TRUNCATE:
It is also a Data Definition Language Command (DDL). It is used to delete all the rows of a relation (table) in one go. With the help of the “TRUNCATE” command, we can’t delete the single row as here WHERE clause is not used. By using this command the existence of all the rows of the table is lost. It is comparatively faster than the delete command as it deletes all the rows fastly.
TRUNCATE TABLE;

THANK YOU FOR WATCHING!