| title | sysmergesubsetfilters (Transact-SQL) | ||
|---|---|---|---|
| description | sysmergesubsetfilters (Transact-SQL) | ||
| author | VanMSFT | ||
| ms.author | vanto | ||
| ms.date | 03/04/2017 | ||
| ms.service | sql | ||
| ms.subservice | replication | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
Contains join filter information for partitioned articles. This table is stored in the publication and subscription databases.
| Column name | Data type | Description |
|---|---|---|
| filtername | sysname | The name of the filter used to create the article. |
| join_filterid | int | The ID of the object representing the join filter. |
| pubid | uniqueidentifier | The ID of the publication. |
| artid | uniqueidentifier | The ID of the article. |
| art_nickname | int | The nickname of the article. |
| join_articlename | sysname | The name of the table to join to determine whether the row belongs. |
| join_nickname | int | The 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 | The 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) | The filter clause used for the join. |
| filter_type | tinyint | Specifies the filter type, which can be one of the following: 1 = Join filter. 2 = Logical record link. 3 = Both a join filter and a logical record link. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)