Replication FAQ series - Which columns are published in snapshot or transactional or merge publications in this database?
Here is script you can find which columns are published in the replication that is using either snapshot or transactional or merge publications.
--For snapshot or transactional publications
select object_name(object_id) as tran_published_table, name as published_column from sys.columns where is_replicated = 1
--For merge publications
select object_name(object_id) as merge_published_table, name as published_column from sys.columns where is_merge_published = 1
