RE: Constraints Lookup

2002-04-24 Thread Thomas Day
: Sent by: rootSubject: RE: Constraints Lookup

Constraints Lookup

2002-04-23 Thread John Weatherman
Yes, this should be easy I need to find all the tables that referance a given table in their constraints. Can somebody help, it's been a long day TIA, John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City

RE: Constraints Lookup

2002-04-23 Thread PILOTTO Diego TECSIS
Try this SELECT a1.constraint_name NAME, DECODE ( a1.CONSTRAINT_TYPE, 'C', 'Check', 'P', 'Primary Key', 'R', 'Referential Integrity', 'U', 'Unique Key', 'V', 'Check Option on a view') TYPE , a1.r_constraint_name RNAME, a1.status, a1.delete_rule, c1.column_name, c1.position,