Query Transactional Replication Article Filters Through the UI, I can see that I have 2 tables with filters on them. I need to be able to query this information but cannot find the table that contains the data. I did a search for any column in the Distribution database with a name like either "Filter" or "Where". The results are below. Unfortunately, none of these tables has the data I'm looking for  in them. 

 - SELECT * FROM IHarticles 
 - SELECT * FROM IHextendedArticleView 
 - SELECT * FROM MSarticles 
 - SELECT * FROM MSmerge_articlehistory 
 - SELECT * FROM MSmerge_articleresolver 
 - SELECT * FROM sysarticlecolumns 
 - SELECT * FROM sysarticles
 - SELECT * FROM sysextendedarticlesview
 - SELECT * FROM sysschemaarticles


Does anyone know where this data is held?
To research this, I configured transactional replication on my test server with 1 article having row filter. I did this for Adventureworks.Sales.Store table having [CustomerID] &lt;10. Initially, I tried querying distribution..sysarticles to check the filter details. But, surprisingly it did not show any data in it.  

Then I checked Adventureworks..sysarticles(i.e. in publication database) and that did the trick. See the below result: