rs_helpreptable

Displays information about replication definitions created against a primary table.

Syntax

rs_helpreptable database, [owner,] {table | '*' }

database – the database where the table is created
owner – the owner of the table
{table | '*' } –
- table – the name of the table
- * wildcard character – all tables. Use the wildcard to list all replication definitions containing tables with the same owner.

Example 1 – Display information about replication definitions for the authors table in the pdb1 database:

rs_helpreptable pdb1, authors

You see:

Replication Definition Name	Primary Owner	Primary Table	Replicate Owner	Replicate Table	Used By	Standby	Min Vers
authors	John	authors	John	authors_r1		Yes	1000
authors1	Bob	authors	Bob	authors_r2		No	1000

Example 2 – Lists all the replication definitions that have Mary as the table owner for tables in the pdb1 database:

rs_helpreptable pdb1, Mary, *

You see:

Replication Definition Name	Primary Owner	Primary Table	Replicate Owner	Replicate Table	Used By	Standby	Min Vers
r1	Mary	t1	Mary	t1		No	1150
r2	Mary	t2	Mary	t2		No	1150

Only user-defined table replication definitions are displayed.
Use the * wildcard character to list all the replication definitions that Replication Server would modify when you use the wildcard in alter replication definition to change table owners that currently have the same owner.