Delete rows from tables
To remove rows from a table, use the DELETE command. You can use the DELETE command to remove specific rows or all rows from a table.
To delete rows, specify the table and an optional search condition (WHERE) that specifies which rows to delete.
Unlike the INSERT and UPDATE commands, the DELETE command requires no column names because it removes entire rows unless you use a qualification.
While the DELETE command removes rows from a table, it does not delete the table definition. Even if you remove all the rows from a table, the table itself still exists. If you want to delete a table definition (and all its associated data), use the DROP TABLE command.
MYDB.SCHEMA(USER)=> DELETE FROM weather WHERE city = 'Hayward';