queryes para listar as chaves estrangeiras e suas colunas, de todas as tabelas do banco.

gistfile1.txt

-- lista as chaves estrangeiras de todas as tabelas;
SELECT TABLE_NAME
  , CONSTRAINT_NAME
  , COLUMN_NAME
  , ORDINAL_POSITION
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE 
WHERE CONSTRAINT_NAME IN (
  SELECT CONSTRAINT_NAME
  FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS)
ORDER BY TABLE_NAME, ORDINAL_POSITION;


-- lista as chaves estrangeiras e suas colunas, de todas as tabelas do banco;
SELECT 
     KCU.CONSTRAINT_NAME AS FK_CONSTRAINT_NAME
  , KCU.TABLE_NAME AS FK_TABLE_NAME
  , KCU.COLUMN_NAME AS FK_COLUMN_NAME
  , KCU.ORDINAL_POSITION AS FK_ORDINAL_POSITION
  , RC.UNIQUE_CONSTRAINT_NAME
 FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC
 JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU
  ON KCU.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG 
      AND KCU.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA
      AND KCU.CONSTRAINT_NAME = RC.CONSTRAINT_NAME
-- \/ buscar tabelas que possuem o mesmo relacionamento com uma tabela específica,
-- por seu nome único gerado com chave estrangeira;
WHERE RC.UNIQUE_CONSTRAINT_NAME = 'atendimento_pkey'
ORDER BY KCU.CONSTRAINT_NAME, KCU.ORDINAL_POSITION