Constraint dependencies

From: Yttri, Lisa <lisa.yttri_at_cnh.com>
Date: Tue, 01 May 2001 14:00:24 -0700
Message-ID: <F001.002F6CB8.20010501135026@fatcity.com>

Hi -

When dropping and/or re-applying constraints for an entire schema, is there a dictionary table that can be queried (or some other way) to determine constraint dependencies - or do you just keep running the script until you do not get those errors? I would like to be able to identify the order that the constraints should be dropped (or added) so that I can write a script to be automated ( for example, to refresh test data from production).

If anyone has any good ideas on how to do this, I'd really be interested in hearing from you.

Thanks -
Lisa Received on Tue May 01 2001 - 16:00:24 CDT