SQL Remote User's Guide
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