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