The interrelations existing between tables can be retrieved using the following commands. Here it is obvious that you must know the system tables well in order to be able to completely survey the relations between the tables.
A query could look like this:
SELECT defowner owner,
deftablename tablename,
defcolumnname columnname,
defkeyname refname,
refowner,
reftablename,
refcolumnname,
rule,
createdate "date",
createtime "time"
FROM domain.fkc_refs_col
WHERE deftablename = 'CUSTOMER'
