compare the table and cdc table columns
select schema_name(schema_id)+'.'+name [Tablename],a.Col from ( SELECT object_id, STUFF((SELECT ',' + cc.[name] FROM sys.columns cc WHERE cc.object_id=c.object_id ORDER BY object_id FOR XML PATH('')), 1, 1, '') AS Col FROM sys.columns c where c.object_id=1481264532 GROUP BY c.object_id) a join sys.tables t on a.object_id=t.object_id where t.is_tracked_by_cdc=1 order by name desc select replace(replace(name,'_CT',''),'_','.') as [TableName],a.Col from ( SELECT object_id, STUFF((SELECT ',' + cc.[name] FROM sys.columns cc WHERE cc.object_id=c.object_id and cc.name not in ('__$start_lsn', '__$end_lsn', '__$seqval', '__$operation', '__$update_mask','__$command_id') ...