Referential Integrity
From: Eitan Mizrahi <eitanm_at_e-ntouch.com>
Date: Sun, 15 Jul 2001 14:00:22 +0200
Message-ID: <3b517810_at_news.barak.net.il>
Date: Sun, 15 Jul 2001 14:00:22 +0200
Message-ID: <3b517810_at_news.barak.net.il>
Hello,
How do I get all of the referential integrity (foreign keys) & all primary
keys,
with one single script that also returns the table name + column name ?
Does anyone have some good scripts with simmilar functionality (such as
returns a list of all tables, etc...) ?
Select * from USER_CONSTRAINTS doesn't answer my question, because it doesn't return column names.
How can I solve the above problem (get all of RI ....)
Thanks :o) Received on Sun Jul 15 2001 - 14:00:22 CEST