REMOVE ALL clauses in the USoft Rule Language serve to identify the table deleted from. They are the equivalent of SQL DELETE clauses. The SQL conditions that identify the records to be deleted (the "WHERE clauses") are introduced by FOR WHICH.
REMOVE ALL clauses are only used in constraint SQL that (potentially) DELETEs data.
where the required and case-insensitive single-string-object-name-plural is the same or similar to the Object Name Plural value for the table as defined in USoft Definer:
•If the Object Name Plural value does NOT contain a space, it is equivalent to the Object Name Plural value, whether surrounded by optional double quotes or not;
•If the Object Name Plural DOES contain one or more spaces, you must surround single-string-object-name-plural by double quotes.
For example, if you have a table BANK_ACCOUNT with Object Name Plural = Bank Accounts, the single-string-object-name-plural is:
and the following are legal variants:
With a subquery: