SQL Guide : solidDB® SQL statements : DROP PUBLICATION
  
DROP PUBLICATION
DROP PUBLICATION publication_name
Usage
The DROP PUBLICATION statement drops a publication definition in the master database. All subscriptions to the dropped publication are dropped automatically as well.
Usage in master
When issued in the master database, the publication definition is removed from the master and replicas will not be able to refresh from it.
Usage in replica
There is no need to define the publications in the replicas, thus the DROP PUBLICATION statement is typically not issued on the replica. If you have created a publication on the replica, the DROP PUBLICATION removes the publication definition from the replica.
Return values
Error code
Description
25010
Publication publication_name not found.
13111
Ambiguous entity name name
Example
DROP PUBLICATION customers_by_area;
Related reference
See also
solidDB® SQL statements