# Deleting rows

Choose DELETE to remove rows while retaining a table, and DROP TABLE to remove its definition as well. The scope of the WHERE condition determines which rows a DELETE removes.

Read [Delete data](https://coordinatordb.com/docs/concepts/features/operations/delete/overview) for RETURNING and transaction behavior.