EnumPublicationReferences Method
この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。 新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。
The EnumPublicationReferences method returns a QueryResults object that enumerates dependency relationships for database objects published as articles.
構文
object.EnumPublicationReferences( )as QueryResults
Parts
- object
Expression that evaluates to an object in the Applies To list
Prototype (C/C++)
HRESULT EnumPublicationReferences(
LPSQLDMOQUERYRESULTS* ppResults);
Returns
A QueryResults object that contains two result sets. The first result set enumerates objects outside the publication that depend on data published by the article, and is defined by these columns.
Column |
Data type |
Description |
|---|---|---|
ArticleObject |
nvarchar(129) |
Name of article publishing referenced data. |
ReferencingObject |
nvarchar(129) |
Name of database object referencing publication data. |
The second result set enumerates database objects not published by the publication and on which an article in the publication depends.
Column |
Data type |
Description |
|---|---|---|
ArticleObject |
nvarchar(129) |
Name of article publishing referencing data. |
ReferencedObject |
nvarchar(129) |
Name of database object referenced and not published. |
説明
The result sets of the QueryResults object contain rows when dependencies exist in the replication database and those dependencies are not reflected in the publication.