|
|
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.