Deletes an existing primary article (or articles) from a specified publication.
sp_dropprimaryart pub_name [, pri_art]
is the name of the publication to which the existing article belongs.
is the name of a primary article. Primary article names can be specified in the form owner.name.
sp_dropprimaryart pubdoc, table1
Deletes the primary article table1 in the publication pubdoc.
Before you invoke sp_dropprimaryart, you must suspend the database connection using sp_suspendprimaryconn. After the primary article is deleted, you can resume the database connection with sp_resumeprimaryconn.
When sp_dropprimaryart is invoked with only a publication name (pub_name) specified, all primary articles in the specified publication are dropped.
When sp_dropprimaryart is invoked with both a publication name (pub_name) and primary article name (pri_art) specified, the specified article in the specified publication is dropped.
If you attempt to drop a primary article that is subscribed to by a replicate article in an associated subscription, sp_dropprimaryart returns an error. You must drop all replicate articles from the associated subscriptions that subscribe to a primary article before you drop the primary article.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.
sp_addprimaryart, sp_droppub, sp_dropreplicateart, sp_helpprimaryart, sp_helpprimaryconn, sp_helppub