sysmergesubsetfilters (Transact-SQL)sysmergesubsetfilters (Transact-SQL)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

包含分区项目的联接筛选信息。Contains join filter information for partitioned articles. 该表存储在发布数据库和订阅数据库中。This table is stored in the publication and subscription databases.

列名称Column name 数据类型Data type 说明Description
filternamefiltername sysnamesysname 用于创建项目的筛选器名称。The name of the filter used to create the article.
join_filteridjoin_filterid intint 表示联接筛选器的对象 ID。The ID of the object representing the join filter.
pubidpubid uniqueidentifieruniqueidentifier 发布 ID。The ID of the publication.
artidartid uniqueidentifieruniqueidentifier 项目的 ID。The ID of the article.
art_nicknameart_nickname intint 项目的别名。The nickname of the article.
join_articlenamejoin_articlename sysnamesysname 表名,要联接该表以确定行是否属于该表。The name of the table to join to determine whether the row belongs.
join_nicknamejoin_nickname intint 表的别名,要联接该表以确定行是否属于该表。The nickname of the table to join to determine whether the row belongs.
join_unique_keyjoin_unique_key intint 指示 join_tablename 的唯一键的联接:Indicates a join on a unique key of join_tablename:

0 = 不是唯一键。0 = Not a unique key.

1 = 是唯一键。1 = A unique key.
expand_procexpand_proc sysnamesysname 存储过程名,合并代理使用该存储过程识别需要向订阅服务器发送或从订阅服务器中删除的行。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_filterclausejoin_filterclause nvarchar(1000)nvarchar(1000) 用于联接的筛选子句。The filter clause used for the join.
filter_typefilter_type tinyinttinyint 指定筛选器类型,可以为下面的一种:Specifies the filter type, which can be one of the following:

1 = 联接筛选器。1 = Join filter.

2 = 逻辑记录链接。2 = Logical record link.

3 = 同时为联接筛选器和逻辑记录链接。3 = Both a join filter and a logical record link.

另请参阅See Also

Transact-sql)(复制表 Replication Tables (Transact-SQL)
复制视图 (Transact-SQL)Replication Views (Transact-SQL)