SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
To remove a column from an article in a publication.
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. |
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.
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