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.