DELETE

DELETE all rows

DELETE certain rows with WHERE

TRUNCATE clause

DELETE certain rows based upon comparisons with other tables