sp_dropmergearticle (T-SQL)

Removes an article from a merge publication.

Syntax

sp_dropmergearticle [@publication =] 'publication', [@article =] 'article'
    [,[@ignore_distributor =] ignore_distributor

Arguments

[@publication =] 'publication'

Is the name of the publication from which to drop an article. publication is sysname, with no default.

[@article =] 'article'

Is the name of the article to drop from the given publication. article is sysname, with no default. If all, all existing articles in the specified merge publication are removed. Even if article is all, the publication still must be dropped separately from the article.

[@ignore_distributor =] ignore_distributor

Indicates whether this stored procedure is executed without connecting to the Distributor. ignore_distributor is bit, with a default of 0.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_dropmergearticle is used in merge replication.

Permissions

Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_dropmergearticle.

See Also