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.
 Anonymous
    
 shared this idea
Anonymous
    
 shared this idea
      
    - 
       AdminDevart
    (_, Devart)
 commented AdminDevart
    (_, Devart)
 commentedDear 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 AdminDevart
    (_, Devart)
 commentedIt's kind of database refactoring feature. 
