Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
goodman2253
Yak Posting Veteran
88 Posts |
 Posted - 2012-06-28 : 09:48:31
|
| Is there any way to find out the relationship of the table with another table in Oracle.I mean to say suppose the table name is table1I have to find those tables in oracle which are linked with these table (table1) either directly or indirectly in oracle |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2012-06-28 : 10:01:31
|
| You may have better luck over at www.dbforums, we're a t-SQL shop here.JimEveryday I learn something that somebody else already knew |
 |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-06-28 : 10:01:59
|
| Try looking at table called: all_constraints and colums like constraint_type and constraint_name.Extract the table name and attach it to constraint, you may gona need to self join the same table.Please, remember that this is an SQL Server Forum, you may be able to get better help in an Oracle Forum.gud luck,--------------------------Get rich or die trying-------------------------- |
|
|
|
|
|
|
How to find relationship of the tables in Oracle