User's Manual

Chapter 18. Command Reference for Adaptive Server Enterprise
sp_drop_publication procedure
Purpose To drop a publication from the database.
Syntax sp_drop_publication publication_name
Argument Description
publication_name The name of the publication to be dropped
See also “sp_create_publication procedure” on page 386
“DROP PUBLICATION statement” [ASA SQL Reference, page 459]
Description Running sp_drop_publication drops a publication from the database. All
articles that make up the publication, and subscriptions to the publication,
are also dropped.
Example
♦ The following statement drops the publication named SalesRep:
sp_drop_publication ’SalesRep’
go
387