sql-delete-Q&A

Question 1

How do you delete rows from a database table?

Answer 1

delete from “table”
where “row” = 24
returning *;

Question 2

How do you accidentally delete all rows from a table?

Answer 2

delete from “table”;