Creating articles containing some of the columns in a table

Creating articles containing some of the rows in a table

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

Creating articles containing some of the columns in a table

To create an article that includes only some of the columns from a table, you need to list the columns that you wish to include, using sp_add_article_col. If no columns are listed, the article includes all columns of the table.

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

Mark the table for replication. You do this by executing the sp_add_remote_table procedure:
```
sp_add_remote_table table-name
go
```
Add the table to the publication. You do this by executing the sp_add_article procedure:
```
sp_add_article publication-name, table-name
go
```
The sp_add_article procedure adds a table to a publication. By default, all columns of the table are added to the publication. If you wish to add only some of the columns, you must use the sp_add_article_col procedure to specify which columns you wish to include.
Add individual columns to the publication. You do this by executing the sp_add_article_col procedure for each column:
```
sp_add_article_col publication-name,
   table-name,
   column-name
go
```

Example

The following commands add only the rep_key column of the table SalesRep to the SalesRepData publication:

sp_add_remote_table 'SalesRep'
sp_add_article 'SalesRepData',
   'SalesRep'
sp_add_article_col 'SalesRepData',
   'SalesRep',
   'rep_key'
go