Dicas com a tag: sql

Consultar as colunas de origem e de destino de uma chave estrangeira (FK) no Oracle, a partir do nome da constraint.

SELECT
    a.table_name  AS tabela_origem,
    a.column_name AS coluna_origem,
    b.table_name  AS tabela_referenciada,
    b.column_name AS coluna_referenciada
FROM
         all_cons_columns a
    JOIN all_constraints  c ON a.constraint_name = c.constraint_name
    JOIN all_cons_columns b ON c.r_constraint_name = b.constraint_name
                               AND a.position = b.position
WHERE
    a.constraint_name = 'NOME_DA_CONSTRAINT';