Note Applies to only solidDB Advanced Replication configurations.
DROPPUBLICATIONpublication‑nameREGISTRATION
Access requirements
In replica: SYS_SYNC_ADMIN_ROLE
Usage
Use the DROP PUBLICATION REGISTRATION statement on a replica database to drop a registration for a publication.
After you drop a registration, the publication definition remains on the master database, but the replica is unable to refresh from the publication. All subscriptions to the registered publication are dropped automatically as well.
The DROP PUBLICATION REGISTRATION statement can be executed only on a replica database.
Note Only use the DROP PUBLICATION REGISTRATION statement if the replica database cannot communicate with the master database and drop the publication subscription (and therefore remove the synchronization history data that remains on the master database). You can remove the history data manually from the master database by using the DROP SUBSCRIPTION statement, see DROP SUBSCRIPTION.