DELETE s use to delete the one or more tuples of a table. With the help of “DELETE” command we can either delete all the rows in one go or can delete row one by one. i.e., we can use it as per the requirement or the condition using Where clause. It is comparatively slower than TRUNCATE cmd. DROP is a Data Definition Language Command (DDL). It is use to drop the whole table. TRUNCATE is a DDL command used to delete all rows in a table.