ra_helparticle

Returns information about primary database articles from the RASD.

Syntax

ra_helparticle [article [, version]]

article – 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.
version – A hexadecimal locator value that identifies the version of the article specified in the article option.

Example 1 –
```
ra_helparticle
```
This command returns information about all versions of all articles in the RASD.
Example 2 –
```
ra_helparticle table1
```
This command returns information about the current version of the article named “table1” in the RASD.
Example 3 –
```
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 Replication Agent is initialized with the pdb_xlog 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.