Re: Determine if Field is being referenced
From: ajay <amehta259_at_yahoo.com>
Date: 27 Dec 2001 01:55:44 -0800
Message-ID: <7ade3e6d.0112270155.4c4df53b_at_posting.google.com>
Date: 27 Dec 2001 01:55:44 -0800
Message-ID: <7ade3e6d.0112270155.4c4df53b_at_posting.google.com>
hi the checking of tables all_cons_columns and all_constraints in your schema or may solve your problem. just desc these tables in the table all_constraints there is a column r_constraint and second one r_table_name which tell you abt the referencing table and columns. bye Received on Thu Dec 27 2001 - 10:55:44 CET