SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
To remove an article from a publication
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. |
Running sp_add_article removes an article from a publication. Any article including parts of the named table is removed from the publication.
The following statement removes any articles that use part of the SalesRep table from a publication named SalesRepData:
sp_remove_article SalesRepData, SalesRep go