Transact-SQL Reference

sysmergesubsetfilters

Contains join filter information for partitioned articles. This table is stored in the publication and subscription databases.

Column name Data type Description
filtername sysname Name of the filter used to create the article.
join_filterid int ID of the object representing the join filter.
pubid uniqueidentifier ID of the publication.
artid uniqueidentifier ID of the article.
art_nickname int Nickname of the article.
join_articlename sysname Name of the table to join to determine whether the row belongs.
join_nickname int Nickname of the table to join to determine whether the row belongs.
join_unique_key int Indicates a join on a unique key of join_tablename:

0 = Not a unique key.
1 = A unique key.

expand_proc sysname Name of the stored procedure used by the Merge Agent to identify the rows that need to be sent or removed from a Subscriber.
join_filterclause nvarchar(1000) Filter clause used for the join.