Re: Report for Extracting Primary and dependant Foreign Keys for a table.

This is a script that works for tables under a single user, may be a starting point....

	select table_name,constraint_name from user_constraints where 
	r_constraint_name = ( select constraint_name from user_constraints where
	table_name = upper('&table') and constraint_type = 'P')

Phil Cook

Andy Smith <andy.smith_at_citicorp.com> wrote in article <33314643.17C1_at_citicorp.com>...
> --
> Does anyone wish to share a script they may have, to identify
> all Foreign keys for a particular Primary key.
>
>
> Regards
> =================================================================
> Andy Smith Email: andy.smith_at_citicorp.com
>
Received on Thu Mar 20 1997 - 00:00:00 CST