Information about synonyms can be found in the table 'syn_refs_tab'. A synonym is defined by using it for referencing a table. The relationships are shown in the column names by the abbreviations 'def' and 'ref'.
CREATE SYNONYM c1 FOR customer
SELECT * FROM syn_refs_tab
Restrict the SELECT list to produce a clearer output list of the synonyms by giving the columns easier names. At the same time, the columns are renamed.
SELECT defsynonymname synonymname,
refowner owner,
reftablename tablename
FROM domain.syn_refs_tab
WHERE defsynonymname = 'NEGATIVE'
