SELECT * FROM sys.tables WHERE is_replicated = 1
从MSDN为is_replicated字段:
1 = Table is published using snapshot replication or transactional replication.