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";
See also
solidDB® SQL statements