Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 18. 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

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 

• The following statement removes the column emp_lname of the employee table from a publication named Personnel:

  sp_remove_article_col 'Personnel', 'employee', 'emp_lname'
  go