User's Manual

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” on page 383
“sp_remove_article procedure” on page 428
“ALTER PUBLICATION statement” [ASA SQL Reference, page 280]
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” on page 383. Although the “sp_add_article procedure” on
page 381, 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
429