Hi Gurus,

I want to find the data model of particular database.
Is this Possible?

Thanks in Advance

Deepak Choudhary


-----Original Message-----
From: LAUWERYSEN Erwin
[mailto:oracledba-ezmlmshield-x69811615.[Email address protected]
Sent: Tuesday, May 03, 2005 3:01 PM
To: LazyDBA Discussion
Subject: RE: Data Dictionary

Perhaps something like this?

select * from user_constraints where constraint_type in ('R','P') and
table_name in (.....)

R is relational key p is primary key

Erwin


-----Original Message-----
From: Choudhry Deepak [mailto:oracledba-ezmlmshield-x99590646.[Email
address protected]
Sent: dinsdag 3 mei 2005 9:39
To: LazyDBA Discussion
Subject: Data Dictionary

Hi Gurus,

I have tables Table A Table B and Table C .

I want to find the relationship can I do that ?

Which are the data dictionary will provide me the information

Thanks In Advance

Deepak Choudhary


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page