DELETE removes specific rows, TRUNCATE removes all rows, DROP removes entire table.

• DELETE is a DML command, TRUNCATE and DROP are DDL commands.

• DELETE can have a WHERE clause to specify which rows to d...read more