DELETE | DROP |
---|---|
DELETE is DML statement | DROP is DDL statement |
DELETE is a SQL Command, removes some or all records from a table | DROP is a SQL Command, which removes different elements of database like table, constraints or entire database schema. |
WHERE clause can be used with DELETE | WHERE can not be used with DROP |