sys.sp_droppublication

Description

Drops a publication and its associated Snapshot Agent. All subscriptions must be dropped before dropping a publication. The articles in the publication are dropped automatically. This stored procedure is executed at the Publisher on the publication database.

Syntax

sp_droppublication
[ @publication = ]
N
'publication'
[ , [ @ignore_distributor = ] ignore_distributor ]
[ , [ @publisher = ]
N
'publisher'
]
[ , [ @from_backup = ] from_backup ]
[ ; ]