Question

Differentiate between the following statement:

DELETE and DROP

Answer 1

Delete

• DELETE Command, removes some or all tuples/records from a relation/table.
• DELETE is DML.
• Delete command can be rollbacked as it works on a data buffer.

Drop

• DROP Command, removes named elements of a schema like relations/table, constraints, or entire schema.
• DROP is DDL.
• Drop command can't be rollbacked as it works directly on data.