VIEW: SYS.USER_SUBSCRIBED_COLUMNS

Source

View Text - Preformatted

SELECT
   s.handle, t.source_schema_name, t.source_table_name, s.column_name,
   u.subscription_name, z.source_database
  FROM sys.cdc_subscribed_columns$ s, sys.cdc_change_tables$ t,
       sys.cdc_subscribers$ u, sys.user$ su, sys.cdc_change_sets$ x,
       sys.cdc_change_sources$ z
  WHERE s.change_table_obj#=t.obj# AND
        s.handle=u.handle AND
        u.username = su.name AND
        su.user#   = userenv('SCHEMAID') AND
        t.change_set_name=x.set_name AND
        x.change_source_name = z.source_name

View Text - HTML Formatted

SELECT S.HANDLE
, T.SOURCE_SCHEMA_NAME
, T.SOURCE_TABLE_NAME
, S.COLUMN_NAME
, U.SUBSCRIPTION_NAME
, Z.SOURCE_DATABASE
FROM SYS.CDC_SUBSCRIBED_COLUMNS$ S
, SYS.CDC_CHANGE_TABLES$ T
, SYS.CDC_SUBSCRIBERS$ U
, SYS.USER$ SU
, SYS.CDC_CHANGE_SETS$ X
, SYS.CDC_CHANGE_SOURCES$ Z
WHERE S.CHANGE_TABLE_OBJ#=T.OBJ# AND S.HANDLE=U.HANDLE AND U.USERNAME = SU.NAME AND SU.USER# = USERENV('SCHEMAID') AND T.CHANGE_SET_NAME=X.SET_NAME AND X.CHANGE_SOURCE_NAME = Z.SOURCE_NAME