SELECT F.foreign_key_id, F.role, PT.table_name, PU.user_name,
       LIST( FC.column_name, ', ' ORDER BY K.foreign_column_id ) AS foreign_column_list,
       LIST( PC.column_name, ', ' ORDER BY K.foreign_column_id ) AS primary_column_list,
       F.check_on_commit, F."nulls", UT.referential_action, DT.referential_action,
       IFNULL( A.attribute_value, 'N', 'Y' ) AS "clustered", F.hash_limit, F.remarks
FROM SYS.SYSFOREIGNKEY F
   JOIN SYS.SYSFKCOL K ON K.foreign_table_id = F.foreign_table_id AND K.foreign_key_id = F.foreign_key_id
   JOIN SYS.SYSCOLUMN FC ON FC.table_id = F.foreign_table_id AND FC.column_id = K.foreign_column_id
   JOIN SYS.SYSCOLUMN PC ON PC.table_id = F.primary_table_id AND PC.column_id = K.primary_column_id
   JOIN SYS.SYSTABLE FT ON FT.table_id = F.foreign_table_id
   JOIN SYS.SYSUSERPERMS FU ON FU.user_id = FT.creator
   LEFT OUTER JOIN SYS.SYSATTRIBUTE A ON A.object_type = 'T' AND A.object_id = FT.table_id AND
                           A.attribute_id =  2  AND A.attribute_value = F.foreign_key_id
   JOIN SYS.SYSTABLE PT ON PT.table_id = F.primary_table_id
   JOIN SYS.SYSUSERPERMS PU ON PU.user_id = PT.creator
   LEFT OUTER JOIN SYS.SYSTRIGGER UT ON UT.foreign_table_id = F.foreign_table_id AND
                          UT.foreign_key_id = F.foreign_key_id AND UT."event" = 'C'
   LEFT OUTER JOIN SYS.SYSTRIGGER DT ON DT.foreign_table_id = F.foreign_table_id AND
                          DT.foreign_key_id = F.foreign_key_id AND DT."event" = 'D'
WHERE FU.user_name = 'DBA' AND FT.table_name = 'sometable'
GROUP BY F.foreign_key_id, F.role, PT.table_name, PU.user_name, F.check_on_commit, F."nulls",
              UT.referential_action, DT.referential_action, "clustered", F.hash_limit, F.remarks
ORDER BY F.role