sql - What is the best way to delete records from one table with over 100 foreign keys?

Question

I know this is not recommended practice. But we need to delete sensitive historical data from one table that has foreign key restraints on about 100 hundred tables so we can QA the consequences. We do not want to delete associated records in other tables.

Is it best to carefully disable every foreign key constraint one at a time? I am looking in to alternatives such as cascade options and global foreign key constraint disabling. Are these safe approaches? I just want to safely disable all the foreign keys and re-enable them in a safe and reliable manner.

question from:https://stackoverflow.com/questions/65892669/what-is-the-best-way-to-delete-records-from-one-table-with-over-100-foreign-keys

Answer 1

Waitting for answers