My requirement is to truncate the data in say 200 tables and copy data from production to lower environment. We have the truncate and insert script for that . But we are struggling to find the tree like structure. For a given 200 tables we need a order of tables for inserting the data without any constraint violation and not disabling the constraints.
Please provide us the query or links to get the answer for this.