Does anyone have a query they are willing to share that displays the table, index, and associated constraint? I found the following query on Jonathan Lewis' site that gives me 2 out of 3 (index and cons), but I can't see a way to grab the associated table. Thanks for any help! Barb http://www.jlcomp.demon.co.uk/faq/constraints_and_indexes.html The connection between constraints and the indexes which are used to check these constraints for the current user can be described by this query: select --+ rule o.owner as index_owner , o.object_name as index_name , n.name as constraint_name from sys.cdef$ c , dba_objects o , sys.con$ n where c.enabled = o.object_id and c.con# = n.con# and n.owner# = uid / ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------