Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 18. Command Reference for Adaptive Server Enterprise       

sp_remove_article procedure

Purpose 

To remove an article from a publication

Syntax 

sp_remove_article publication_name, table_name

Argument	Description
publication_name	The name of the publication from which the article is to be deleted.
table_name	The table containing the article.

See also 

sp_add_article procedure

Description 

Running sp_add_article removes an article from a publication. Any article including parts of the named table is removed from the publication.

Example 

• The following statement removes any articles that use part of the SalesRep table from a publication named SalesRepData:

  sp_remove_article SalesRepData, SalesRep
  go