Home » Other » General » table mapping
table mapping [message #104189] Fri, 13 August 2004 10:13 Go to next message
Larry
Messages: 11
Registered: September 2002
Junior Member
How do I find out what columns are associated (linked) with columns in other tables? Is there an application that will do this for me? Since there are a lot of tables running code against every one will not be very productive.
Re: table mapping [message #104227 is a reply to message #104189] Wed, 25 August 2004 13:40 Go to previous message
Moi
Messages: 15
Registered: August 2004
Junior Member
Have you looked at the system tables (there are lots of them!)

Try:

USER_CONS_COLUMNS
ALL_CONS_COLUMNS
OR
USER_CONSTRANTS
ALL_CONSTRANTS

These may help a little.
Previous Topic: for DBA
Next Topic: Serial port data into Oracle database
Goto Forum:
  


Current Time: Fri Apr 26 04:37:33 CDT 2024