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. |
| 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. |