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,
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' ANDpg_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-lReceived on Sat Apr 28 2012 - 14:04:30 CDT