SQL Delete Command
This command is used to delete rows or records in a table. The syntax of this command is:
delete from "tablename"
where columnname OPERATOR value [and|or
columnnamex OPERATOR valuex];
Without the where clause, all records in the table will be deleted.
delete from citylist
where name = 'Argos' and state = 'Indiana';