Contents Index sp_remove_article procedure sp_remove_remote_table procedure

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

sp_remove_article_col procedure


Purpose 

To remove a column from an article in a publication.

Syntax 

sp_remove_article_col publication_name,
article_name,
column_name

Argument Description
publication_name The name of the publication to which the article belongs.
article_name The article from which the column is to be removed.
column_name The column to be removed from the article.
See also 

sp_add_article_col procedure

sp_remove_article procedure

ALTER PUBLICATION statement

Description 

You can remove a column from a publication using sp_remove_article_col.

To remove a column using sp_remove_article_col, the column must have been explicitly added to a publication using the sp_add_article_col procedure. Although the sp_add_article procedure, without use of sp_add_article_col, adds all the columns of a table to a publication, you cannot remove a single column from such a publication using sp_remove_article_col.

Example 

Contents Index sp_remove_article procedure sp_remove_remote_table procedure