Try using DBA_CONSTRAINTS (if you have access to it), or USER_CONSTRAINTS.
Use the fields of constraint_name, owner, table_name in the WHERE clause for
the table(s) that contain the constraints.
matthew taylor <s176226_at_student.uq.edu.au> wrote in message
news: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 - 20:48:59 CST
