Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The EnumAllSubsetFilters method returns a QueryResults object that enumerates the join filters defined within a merge replication publication.
Syntax
object
.EnumAllSubsetFilters( )
as
QueryResults
Parts
- object
Expression that evaluates to an object in the Applies To list.
Prototype (C/C++)
HRESULT EnumAllSubsetFilters(
LPSQLDMOQUERYRESULTS* ppResults);
Returns
A QueryResults object that contains one result set defined by these columns.
| Column | Data type | Description |
|---|---|---|
article name |
nvarchar(129) |
Name of the article that contains the joined from table. |
base table name |
nvarchar(129) |
Name of the table joined to in the filter clause. |
base table owner |
nvarchar(129) |
Name of the owner of the table joined to in the filter clause. |
filtername |
nvarchar(129) |
Name of the filter. |
join article name |
nvarchar(129) |
Name of the article on which the filter is defined. |
join table name |
nvarchar(129) |
Name of the table joined from in the filter clause. |
join table owner |
nvarchar(129) |
Name of the owner of the table joined from in the filter clause. |
join_filterclause |
nvarchar(1001) |
Transact-SQL WHERE clause that defines the filter. |
join_filterid |
integer |
System-generated identifier. |
join_unique_key |
integer |
When 1, the filter depends on a unique or key value. When 0, the filter does not depend on a unique value. |