Finding constraints in existing database

From: matthew taylor <s176226_at_student.uq.edu.au>
Date: 2000/03/03
Message-ID: <38BF684D.2E8C1A6C@student.uq.edu.au>#1/1

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