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” on page 381
“ALTER PUBLICATION statement” [ASA SQL Reference, page 280]
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
428