DROP PUBLICATION REGISTRATION

SQL Guide : solidDB® SQL statements : DROP PUBLICATION REGISTRATION

DROP PUBLICATION publication_name REGISTRATION

Usage

The DROP PUBLICATION REGISTRATION statement drops a registration for a publication in the replica database. The publication definition remains on the master database, but a user will be unable to refresh from the publication. All subscriptions to the registered publication are dropped automatically as well.

The DROP PUBLICATION REGISTRATION statement can only be issued on the replica database.

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;