solidDB Help : solidDB reference : SQL: Statements : DROP PUBLICATION REGISTRATION
  
DROP PUBLICATION REGISTRATION
Note Applies to only solidDB Advanced Replication configurations.
DROP PUBLICATION publication‑name REGISTRATION
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.
Return values
 
Error code
Description
13047
No privilege for operation
25019
Database is not a replica database
25025
Node name not defined
25071
Not registered to publication publication‑name
Example
DROP PUBLICATION customers_by_area REGISTRATION;
Go up to
SQL: Statements