PQL Delete

The PQL DELETE Statement
The DELETE statement is used to delete records in a stable.

PQL DELETE Syntax
Note: Notice the WHERE clause in the DELETE syntax. The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!

PQL DELETE Example
The "Ponies" stable:

Now we want to delete the pony "MareDoWell, Mysterious" in the "Ponies" stable.

We use the following PQL statement:

The "Ponies" stable will now look like this:

Delete All Rows
It is possible to delete all rows in a stable without deleting the stable. This means that the stable structure, attributes, and indexes will be intact:

or

Note: Be very careful when deleting records. You cannot undo this statement!