|
The DELETE FROM command removes one or more rows (tuples) of a table
(relation). The WHERE-clause specifies which tuples have to
be deleted. If it is missing, all tuples are deleted!
The syntax is: DELETE FROM
<Tablename>WHERE
<Condition>;
DELETE FROM
is used without
WHERE
, all datasets of this table are deleted. This is irreversible in most systems.