Syntax: 

DELETE FROM [catalog-name.]table-name [ WHERE expr ]
	

The DELETE command is used to remove records from a table.

Without the WHERE clause, all rows of the table are removed. If the WHERE clause is present only the rows that match the expression are removed.