后续版本的 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.