sysmergesubsetfilters (T-SQL)

Contains join filter information for partitioned articles. This table is stored in the published database.

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_tablename sysname Name of the table to join to determine if the row belongs.
join_nickname int Nickname of the table to join to determine if 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.
join_filterclause nvarchar(1000) Filter clause used for the join.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.