The SQL DROP command is used to remove an object from the database. The DELETE Statement is used to delete rows from a table.
The truncate command removes all rows from a table or specified partitions of a table, without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement.