613-518-1166 info@zimdatabases.com

ZIM Language Reference


< All Topics

Deletes records from EntitySets or relationships with fields.


DELETE [ALL] FROM SQLsetspec [EVALUATE clause] [-> clause]


ALL Optional. Whether or not you include the ALL argument, all records in SQLsetspec are deleted.
SQLsetspec An SQL set specification. If omitted, records are deleted from the current set (if it exists).


DELETE FROM is the SQL version of the DELETE command.

Records cannot be deleted from a composite set. Data cannot be deleted from application documents or forms.

DELETE FROM acts by default on all records in SQLsetspec. By contrast, DELETE acts by default on only the first record in a set.

Warning: You cannot recover data deleted by the DELETE FROM command. If no backup copy of the data exists, the data is permanently lost.


delete from Employees where LastName = “Smith”

Deletes every employee whose last name is Smith.

delete from Fields where Length > (select avg (length) from Fields)

Deletes every field whose length is greater than the average length of all fields.

See Also



Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents