sysmergesubsetfilters (Transact-SQL)

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.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance