MASS DELETE RESTRICTION IN A DATABASE

摘要

In an approach for limiting mass deletions from database tables, a computer receives a deletion request corresponding to data in a database table. The computer determines whether the database table includes a restriction of a mass deletion. Responsive to determining the database table includes a restriction of a mass deletion of data from a database table, the computer determines whether the quantity of data in the deletion request exceeds the restriction of a mass deletion. Responsive to determining the quantity of data in the deletion request exceeds the restriction of a mass deletion, the computer prevents execution of the deletion request.

主权项

1. A method for limiting mass deletions from database tables, the method comprising:
a computer receiving a deletion request corresponding to data in a database table; the computer determining whether the database table includes a restriction of a mass deletion of data from a database table; the computer, responsive to determining the database table includes a restriction of a mass deletion of data from a database table, determining whether the quantity of data in the deletion request exceeds the restriction of a mass deletion; and the computer, responsive to determining the quantity of data in the deletion request exceeds the restriction of a mass deletion, preventing execution of the deletion request.