1 of 1

Error 1701: Cannot truncate a table referenced in a foreign key constraint

Error Code

SQLSTATE

Error

Description

1701

42000

ER_TRUNCATE_ILLEGAL_FK

Cannot truncate a table referenced in a foreign key constraint (%s)

Possible Causes and Solutions