ERROR[1451] Reported When a Table with Foreign Keys Cannot Be Deleted

Scenario

The root user does not have the permissions required to delete or modify tables in the database. Error message is as follows:

ERROR[1451] -Cannot deleteorupdatea parent row:

aforeignkeyconstraintfails (…)

Fault Analysis

The FRM file also exists in sys_tables. This table has foreign key relationships with other tables and cannot be deleted directly.

The foreign key association has been set in the RDS for MySQL DB instance. As a result, data cannot be updated or deleted. You can set foreign_key_checks to avoid this problem.

Solution

set session foreign_key_checks=off;
drop table table_name;

To delete the table, set foreign_key_checks to off.