Hi, Which view will tell how many tables are refering that columns? Let us consider one table tab1 with pk ID,I wanted to know which others tables are refeing ID as FK/reference key. thanks -Seema _________________________________________________________________ Don?t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- //www.freelists.org/webpage/oracle-l