Re: foreign key dependencies?

        There is a script at www.solvit.net/dbscripts/pkfk.htm that looks like it will do what you want.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/30/00, 4:53:08 PM, dcowles_at_i84.net (Doug Cowles) wrote regarding Re: foreign key dependencies?:

> I know how to check the foreign keys.. I was just hoping there might
> be a script to do it recursively rather than by hand...
> Anyone out there have a script? I guess I could write one with some
> sort of a winding stack as to what tables have foreign keys...
 

> - D

> On Sun, 30 Apr 2000 17:08:29 GMT, "Dadd" <Dadd_at_cp.com> wrote:
 

> >Doug,
> >Have a look at view USER CONSTRAINTS where CONSTRAINT TYPE = 'R'
> >"R" for references.
> >Each row is a FK constraint pointing to other PK or unique
 constraint.
> >HTH
> >
> >"Doug Cowles" <dcowles_at_i84.net> wrote in message
> >news:39109476.20691183_at_news.remarq.com...
> >> I'm interested in analyzing a schema for foreign key dependencies f
 or
> >> the purpose of archiving..
> >> In other words, if I want information in a certain table, what is t
 he
> >> chain of foreign keys to other tables that will require me to archi
 ve
> >> 2 or 3 tables in order to set the dependencies for the one table I
> >> want.
> >>
> >> In other words, I'm looking for chains of parents...
> >> Like if I have a table A that I want to archive, and it has a forei
 gn
> >> key to B, and B has a foreign key to C which has a foreign key to D
 ,
> >> I'm looking for
> >> A B C D
> >> B C D
> >> C D
> >> D
> >>
> >> - this sort of thing...
> >> any "Dependency" view or a connect by prior something that will all
 ow
> >> this sort of analysis?
> >>
> >> Thanks,
> >> Dc.
> >
> >
Received on Mon May 01 2000 - 00:00:00 CDT