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 for RETURNING and transaction behavior.