EnumAllSubsetFilters Method
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。
The EnumAllSubsetFilters method returns a QueryResults object that enumerates the join filters defined within a merge replication publication.
語法
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. |