Command Reference for Adaptive Server Enterprise
To drop a publication from the database.
sp_drop_publication publication_name
| Argument | Description |
|---|---|
| publication_name | The name of the publication to be dropped |
sp_create_publication procedure
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.
The following statement drops the publication named SalesRep:
sp_drop_publication 'SalesRep' go
SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.