SQL - Select's utéis - Relaciona todas tabelas pai/filhas - www.cadcobol.com.br
SELECT R.REFTBNAME AS PAI , F.TBNAME AS FILHA , F.COLSEQ AS SEQ_COL , F.COLNAME AS "NOME DA COLUNA" , CASE R.DELETERULE WHEN 'C' THEN 'DELETE CASCATE' WHEN 'N' THEN 'SET NULL' WHEN 'R' THEN 'RESTRICT' WHEN 'A' THEN 'NO ACTION' END AS "REGRA DELECAO" FROM SYSIBM.SYSFOREIGNKEYS F , SYSIBM.SYSRELS R WHERE F.CREATOR = R.CREATOR AND F.CREATOR = 'CAD' AND F.TBNAME = R.TBNAME AND F.RELNAME = R.RELNAME ORDER BY F.CREATOR , F.TBNAME , R.REFTBCREATOR , R.REFTBNAME
PAI FILHA COL NOME DA COLUNA REGRA DELECAO ------------------ ------------------ ------ ------------------ ------------- CADTB012_SERVIDOR CADTB011_DBO_PRSTO 1 NU_CPF RESTRICT CADTB012_SERVIDOR CADTB011_DBO_PRSTO 2 NU_ORGAO RESTRICT CADTB015_SQNCL_CNO CADTB011_DBO_PRSTO 1 NU_AGENCIA_CNTRO RESTRICT CADTB015_SQNCL_CNO CADTB011_DBO_PRSTO 4 NU_DV_CONTRATO RESTRICT CADTB015_SQNCL_CNO CADTB011_DBO_PRSTO 3 NU_CONTRATO RESTRICT CADTB015_SQNCL_CNO CADTB011_DBO_PRSTO 2 NU_OPERACAO_CNTRO RESTRICT CADTB016_CONVENIO CADTB011_DBO_PRSTO 1 CO_TIPO_CONVENIO RESTRICT CADTB017_SITUACAO CADTB011_DBO_PRSTO 1 CO_SITUACAO_PRSTO RESTRICT CADTB013_ORGAO CADTB012_SERVIDOR 1 NU_ORGAO RESTRICT CADTB021_STCO_PRST CADTB020_DBO_CONTR 2 NU_CONVENIO RESTRICT CADTB021_STCO_PRST CADTB020_DBO_CONTR 1 CO_SITUACAO_PRSTO RESTRICT CADTB022_ORGAO CADTB020_DBO_CONTR 2 NU_CONVENIO RESTRICT CADTB022_ORGAO CADTB020_DBO_CONTR 1 NU_ORGAO RESTRICT CADTB024_FNCO_ORGO CADTB020_DBO_CONTR 3 NU_CONVENIO RESTRICT CADTB024_FNCO_ORGO CADTB020_DBO_CONTR 2 NU_ORGAO RESTRICT CADTB024_FNCO_ORGO CADTB020_DBO_CONTR 1 NU_CPF_CGC RESTRICT CADTB025_LOTE CADTB020_DBO_CONTR 3 DT_MOVIMENTO RESTRICT CADTB025_LOTE CADTB020_DBO_CONTR 1 NU_LOTE RESTRICT CADTB025_LOTE CADTB020_DBO_CONTR 2 NU_CONVENIO RESTRICT CADTB026_TIPO_AVRB CADTB020_DBO_CONTR 1 NU_AVERBACAO RESTRICT CADTB023_CONVENIO CADTB022_ORGAO 1 NU_CONVENIO RESTRICT CADTB022_ORGAO CADTB024_FNCO_ORGO 2 NU_CONVENIO RESTRICT CADTB022_ORGAO CADTB024_FNCO_ORGO 1 NU_ORGAO RESTRICT CADTB022_ORGAO CADTB027_CNTE_ORGO 2 NU_CONVENIO RESTRICT CADTB022_ORGAO CADTB027_CNTE_ORGO 1 NU_ORGAO RESTRICT CADTB025_LOTE CADTB027_CNTE_ORGO 1 NU_LOTE RESTRICT CADTB025_LOTE CADTB027_CNTE_ORGO 2 NU_CONVENIO RESTRICT CADTB025_LOTE CADTB027_CNTE_ORGO 3 DT_MOVIMENTO RESTRICT CADTB057_IND_CRED CADTB055_CON_SEGRE 1 NU_INDIC_CREDITO RESTRICT
