is there a way to know all filters applied to one publication with query (SQL Server 2014)?

Posted on

Question :

I’m looking for a way to get all filters applied to all my publication… I know that I can right click properties -> Filter Rows but is there a way to view them with a query?

Answer :

You can use the table sysaticle but if you don’t find it, there is an alternative table sysmergearticles it has all the filters in column subset_filterclause.

Leave a Reply

Your email address will not be published. Required fields are marked *