DataFaucet ORM

Delete Statement

A delete statement removes data from the target table and can optionally handle the update or deletion of data in related tables automatically.

Delete statements can be filtered.

The Delete object has these properties:

PropertyDefaultDescription
tablen/aThe table from which data is returned
nullForeignKeystrueboolean - if true the tag will set nulls on any foreign keys in related tables which reference the primary key values in the deleted records when applicable (the foreign key is nullable)
deleteForeignKeystrueboolean - if true the tag will delete any records in related tables which reference the primary key value in the deleted records - this is done after nulls are set, allowing related records to be saved when possible
includeandand/or - indicates whether filters are cumulative (and) or mutually exclusive (or)