Returns information about primary database articles from the RASD.
This command is available only for Oracle and Microsoft
SQL Server.
ra_helparticle [article, [version]]
The name or object ID of an article (table or procedure) in the primary database. Article names can be qualified with an owner name in the following form:
owner.article
Owner qualification of article names is optional.
A hexadecimal locator value that identifies the version of the article specified in the article option.
ra_helparticle
This command returns information about all versions of all articles in the RASD.
ra_helparticle table1
This command returns information about the current version of the article named “table1” in the RASD.
ra_helparticle table1, 00000000000210a400003334000700003334000699940000d413c50000000000
This command returns information about version 00000000000210a400003334000700003334000699940000d413c50000000000 of the article named “table1” in the RASD.
The ra_helparticle command returns the following information for articles (tables and procedures):
Article object ID
Primary database name
Article owner name or alias
Article name
Article type (table or procedure)
Article status (Current, Archived, or Dropped)
Article version number
All information except the article type, article status, and article version number are the values returned by the primary database when the Replication Agent is initialized with the ra_init command.
If ra_helparticle is invoked with no option, it returns information for all versions of all articles (tables and procedures) in the RASD.
If ra_helparticle is invoked with the article option, it returns information only for the current version of the specified article in the RASD.
If ra_helparticle is invoked with the article and version options, it returns information only for the specified version of the specified article in the RASD.
The ra_helparticle command is valid when the Replication Agent instance is in the Admin, Replicating, or Replication Down state.
