SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Enterprise
    Creating publications

Creating whole-table articles

The simplest type of article is one that includes all the rows and columns of a database table.

To create an article that includes all the rows and columns of a table

1. Mark the table for replication. You do this by executing the sp_add_remote_table procedure:

   sp_add_remote_table table-name

2. Add the table to the publication. You do this by executing the sp_add_article procedure:

   sp_add_article publication-name, table-name

Example 

• The following commands add the table SalesRep to the SalesRepData publication:

  sp_add_remote_table 'SalesRep'
  sp_add_article 'SalesRepData', 'SalesRep'
  go