Sometimes we ask our DBA to copy data from production environment into test. After DBA truncates all the tables in test, he does his ‘magic’ of copying data from production. But, of course, tables have FK (foreign keys) and need to have data in ‘look-up’ tables first where the PK (primary key) is.
So question: is there a way (for DBA) to find all tables without FK? (so he can copy these tables first.)
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.