Contents Index sp_add_article procedure sp_add_remote_table procedure

SQL Remote User's Guide
  Command Reference for Adaptive Server Enterprise

sp_add_article_col procedure


Purpose 

To add a column to an article in a publication.

Syntax 

sp_add_article_col publication_name,
table_name,
column_name

Argument Description
publication_name The name of the publication to which the article is to be added.
table_name The table containing the article.
column_name The column to be added to the article in a publication
See also 

sp_add_article procedure

sp_remove_article procedure

ALTER PUBLICATION statement

Description 

Running sp_add_article_col adds a column to an article in a publication. The table must first be added to the publication using the sp_add_article procedure.

To add all the columns of a table to a publication you do not need to use sp_add_article_col; just call sp_add_article.

To add only some of the columns of a table to a publication you first call sp_add_article, and then call sp_add_article_col for each of the columns you wish to include in the publication.

As with other data definition changes, in a production environment this procedure should only be run on a quiet SQL Remote installation.

For more information on the requirements for a quiet system, see Making schema changes.

Example 

Contents Index sp_add_article procedure sp_add_remote_table procedure