table referenced by

From: jo <jose.soares_at_sferacarta.com>
Date: Sat, 28 Apr 2012 21:04:30 +0200
Message-ID: <4F9C3F3E.7070109_at_sferacarta.com>



Hi all,

I'm trying to create a query to know which tables are linked with table 'anagrafica'
in PostgreSQL I can achieve it with this query:

SELECT 'anagrafica' AS table,
conrelid::pg_catalog.regclass AS referenced_by, conname AS foreignkey_name
FROM pg_catalog.pg_constraint c
WHERE c.contype = 'f'
AND c.confrelid = (

     SELECT c.oid FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
     WHERE c.relname = 'anagrafica' AND 
pg_catalog.pg_table_is_visible(c.oid)

    )

   table    |      referenced_by       |                  foreignkey_name
------------+--------------------------+----------------------------------------------------
 anagrafica | asl                      | asl_id_anagrafica_fkey
 anagrafica | azienda                  | azienda_id_anagrafica_fkey


Is it possible to do do the same thing in Oracle?

j

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 28 2012 - 14:04:30 CDT

Original text of this message