Deletes an existing publication.
sp_droppub pub_name
is the name of the publication to delete.
sp_droppub pubdoc
Deletes the publication pubdoc.
Before you invoke sp_droppub, you must suspend the database connection using sp_suspendprimaryconn. After the publication is deleted, you can resume the database connection with sp_resumeprimaryconn.
If a publication has any primary article defined for it, you must drop the primary article before you drop the publication.
If you attempt to drop a publication that has a primary article defined, sp_droppub returns an error.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.
sp_addpub, sp_dropsub, sp_helpprimaryart, sp_helpprimaryconn, sp_helppub
