SQL Delete

Question 1

How do you delete rows from a database table?

Answer 1

An SQL delete statement is how rows get removed from tables.

delete from “products”
where “productId” = 24
returning *;

Question 2

How do you accidentally delete all rows from a table?

Answer 2

By not specifying the rows to be deleted by using the ‘where’ clause.