Kenneth Fisher disturbs the slumber of the forces of replication:
The other day I was asked to supply a list of all of the tables being replicated into a given database. Now, for those of you that aren’t aware, if I replicate a group of tables from database SourceDB into DestDB I can still have additional tables in DestDB that have nothing to do with the replication. So this wasn’t just a matter of getting a list of tables from the database.
Click through for queries which work for transactional replication as well as merge replication.