constraints

Hi,

I've just written a sql report which prints all tables and indexes for a particular user. The contents include table name, comment constraint type and search condition etc.

My question is - where does oracle store the references constraint detail's, ie which table and associated column is referenced for a constraint type of 'R'.

From the report I can see a particular column is referenced from the constraint type but to find which table and column it references at the moment I'd have to refer back to the sql command file which generated the table.

Surely oracle must store this info in the data dictionary somewhere as it uses it when automatically writing default triggers in sqlforms or when a drop table command is issued. I've searched the data dictionary with no luck!

Any Ideas ??

Simon.Rear_at_Almac.Co.Uk

---
 ~ OLX 2.1 TD ~ Ever stop to think and forget to start again?
--
ALMAC BBS Ltd. 0324-665371
Dos based USENET access,  call for details!