[Home] [Help]
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')
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')
|
|
|
|