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