Disable foreign keys when deleting or truncating table
When deleting or truncating a table I would like to have the option to disable foreign key checks for this operation. This could be a simple check box which is unchecked by default.
If foreign keys are present, I either have to drop the database and recreate the whole schema or delete one-by-one figuring out the correct order or I have to write an SQL script with a lot of drop table statements and surrounding them with the foreign key checks setting.
This is cumbersome, especially for development purposes when I have to clear test data very often or deploy schema changes.
-
AdminDevart (_, Devart) commented
Dear User,
Thanks for your comment!
At the moment, a similar option has been implemented.
We kindly request you to update and reevaluate
Best,
Devart Support Team -
AdminDevart (_, Devart) commented
It's kind of database refactoring feature.