About Delete Queries

A Delete query deletes records that meet the criteria in the query from the database. Delete queries delete entire records, not just individual fields in records.

If you need to delete many records at once, this type of query can save you time. For example, suppose you created various records in a family and later determined that those records were invalid. You could create a Delete query to delete those records from the family based on the desired criteria, such as a value in the record, the creation date, or the user who created them.

Only Super Users and members of the MI Power User Role Security Group can create Delete queries. All users can run Delete queries, provided that they have been granted permissions to the Catalog folder in which they are stored. To delete the records returned by the query, a user must have Delete permissions on the family to which those records belong.

Note: Deletions performed by a Delete query cannot be undone.