From: "Kailash Awati" <awatik@yahoo.com>
Subject: Re: Finding constraints in existing database
Date: 2000/03/03
Message-ID: <89o3vb$kss$1@news.online.de>#1/1
References: <38BF684D.2E8C1A6C@student.uq.edu.au>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: abuse@online.de
X-Trace: news.online.de 952079147 21404 62.158.194.200 (3 Mar 2000 10:25:47 GMT)
Organization: 1&1 Telekommunikation GmbH
NNTP-Posting-Date: 3 Mar 2000 10:25:47 GMT
Newsgroups: comp.databases.oracle.misc


Hi Matthew,

Try selecting from USER_CONSTRAINTS (for constraint info) and
USER_CONS_COLUMNS (for tables and column details).

Hope this helps,

Kailash.

matthew taylor wrote in message <38BF684D.2E8C1A6C@student.uq.edu.au>...
>a while ago i discovered
>select * from USER_TABLES;
>
>and the resulting flood of information when filtered yielded all kinds
>of interesting information.... like all the names of tables in the table
>space etc.
>
>I'm still wading through various manuals to get the hang of things in
>Oracle but I'm curious, is there a quick and easy way to find
>constraints that have been setup on a database?? ie. is it something
>like
>
>select blah from constraints_blah    ???
>
>
>Got myself all happy the other day when I jdbc connected across network
>to an access database, now to move onto a jdbc connection across
>webserver and do some dynamic content in web pages.
>
>
>Matthew