SQL Guide : solidDB® SQL statements : DROP MASTER
  
DROP MASTER
DROP MASTER master_name
Usage
The DROP MASTER statement drops the master database definitions from a replica database. After the drop, the replica cannot synchronize with the master database. The DROP master statement can only be used in the replica database.
If master_name is a reserved word, it must be enclosed in double quotation marks.
To use the DROP MASTER statement, autocommit must be set off.
Note The preferred way to stop using the master database is to unregister the replica. The DROP MASTER statement should be 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
25007
Master master_name not found
25019
Database is not a replica database
25056
Autocommit not allowed
25065
Unfinished message message_name found for master master_name
Examples
DROP MASTER "MASTER"; DROP MASTER MY_MASTER;
See also
solidDB® SQL statements