DROP REPLICA

SQL Guide : solidDB® SQL statements : DROP REPLICA

DROP REPLICA

DROP REPLICA replica_name

Usage

The DROP REPLICA statement drops a replica database from the master database. After this operation, the dropped replica cannot synchronize with the master database. The DROP REPLICA statement can only be issued on the master.

If replica_name is a reserved word, it must be enclosed in double quotation marks.

To use the DROP REPLICA statement, autocommit must be set off.

Note The preferred way for stopping to use the replica is to unregister the replica. The DROP REPLICA statement is used only when the MESSAGE APPEND UNREGISTER REPLICA statement cannot be executed. For details on unregistering a replica, see MESSAGE APPEND.

Return values

Error code	Description
13047	No privilege for operation
25009	Replica replica_name not found
25020	Database is not a master database
25056	Autocommit not allowed
25064	Unfinished message message_name found for replica replica_name

Examples

DROP REPLICA salesman_smith ; DROP REPLICA "REPLICA";