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