zOs/SQL/RI

-- referential integrity
-- show tables and referenced tables plus relAttributes
select
        char(creator, 8) "tabCrea",
        char(tbname, 20) "table",
        char(relName ,12) "rel",
        r.deleteRule "ru", r.enforced "en", r.colcount "cols",
        char(refTBcreator, 8) "refCrea",
        char(refTBname, 20) "refTab"
    from sysibm.sysrels r
    where (tbname like 'T%' or refTBname like 'T%')
    order by tbName, refTbName, relName, creator
;