Re: Finding constraints in existing database

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_at_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
Received on Fri Mar 03 2000 - 00:00:00 CST