DROP MASTER

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;