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';