Sybase SQL Remote DC38133-01-0902-01 User Manual

Page of 485
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
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