table mapping [message #104189] |
Fri, 13 August 2004 10:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|