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.

Example

delete from citylist
where name = 'Argos' and state = 'Indiana';