select
c.sname,
c.oname,
c.group_name,
c.group_comment
from system.repcat$_column_group c, all_repobject o
where c.sname = o.sname and c.oname = o.oname
and o.type in ('TABLE', 'SNAPSHOT')
View Text - HTML Formatted
SELECT
C.SNAME ,
C.ONAME ,
C.GROUP_NAME ,
C.GROUP_COMMENT
FROM SYSTEM.REPCAT$_COLUMN_GROUP C , ALL_REPOBJECT O
WHERE C.SNAME = O.SNAME AND C.ONAME = O.ONAME
AND O.TYPE IN ('TABLE' , 'SNAPSHOT')