Delete vs Drop

Delete is a Data Manipulation Language command, DML command and is used to remove tuples/records from a relation/table. Whereas Drop is a Data Definition Language, DDL command and is used to remove named elements of schema like relations/table, constraints or entire schema.

Posted September 12, 2022 by Rohith and Anusha ‐ 1 min read

quick-references blog delete drop differences

Delete vs Truncate

Both the Truncate statement and the Delete statement are included in the category of SQL queries for deleting the data stored in a table. They carry out deletion operations on records or rows of a table that are no longer needed.

Posted September 12, 2022 by Rohith ‐ 2 min read

quick-references blog delete truncate differences

Subscribe For More Content