solidDB Help : solidDB reference : SQL: Statements : DROP MASTER
  
DROP MASTER
Note Applies to only solidDB Advanced Replication configurations.
DROP MASTER master‑name
Access requirements
In replica: SYS_SYNC_ADMIN_ROLE
Usage
Use the DROP MASTER statement to drop the master database definitions from a replica database. After you drop the master database definitions, the replica database cannot synchronize with the master database.
The DROP MASTER statement can be used only in a replica database.
If master‑name is a reserved word, it must be enclosed in double quotation marks.
To use the DROP MASTER statement, autocommit mode must be switched off.
Note The preferred way to stop a replica database from synchronizing with the master database is to unregister the replica database. Use the DROP REPLICA statement only when you cannot use the MESSAGE APPEND UNREGISTER REPLICA statement. For details about unregistering a replica database, 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
Example
DROP MASTER "MASTER"; DROP MASTER MY_MASTER;
Go up to
SQL: Statements