solidDB Help : solidDB reference : SQL: Statements : DROP REPLICA
  
DROP REPLICA
Note Applies to only solidDB Advanced Replication configurations.
DROP REPLICA replica‑name
Access requirements
In master: DBA or SYS_SYNC_ADMIN_ROLE
Usage
Use the DROP REPLICA statement on the master database to drop a replica database.
After this operation, the dropped replica database cannot synchronize with the master database. The DROP REPLICA statement can be executed only on the master database.
If replica‑name is a reserved word, it must be enclosed in double quotation marks.
To use the DROP REPLICA 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
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";
Go up to
SQL: Statements