knex-db-manager icon indicating copy to clipboard operation
knex-db-manager copied to clipboard

dbManager.truncateDb - cannot truncate a table referenced in a foreign key constraint

Open chalcrow opened this issue 3 years ago • 1 comments

Hi - thanks for the package. When I'm trying to truncate I get the error cannot truncate a table referenced in a foreign key constraint. Is there any way to CASCADE the truncate to get around this?

chalcrow avatar Mar 15 '21 01:03 chalcrow

If you truncate all the related tables at the same time that error shouldn't happen.

elhigu avatar Mar 15 '21 02:03 elhigu