Removes a failover group from the account.
CREATE FAILOVER GROUP , ALTER FAILOVER GROUP , SHOW FAILOVER GROUPS
DROP FAILOVER GROUP [ IF EXISTS ] <name>
Copy
Parameters¶name
Specifies the identifier for the failover group.
Only an account administrator (user with the ACCOUNTADMIN role) or the group owner (role with the OWNERSHIP privilege on the group) can execute this SQL command.
A primary failover group can only be successfully dropped if no linked secondary failover groups exist.
A database that is included in a failover group is not dropped when the failover group is dropped.
If a secondary failover group is dropped, any database previously included in the group loses read-only protection and becomes writable.
If the secondary failover group is re-created from the same primary failover group as before, the databases in the group are overwritten by the databases in the primary failover group during the first refresh. These databases are read-only.
To retrieve the set of accounts in your organization that are enabled for replication, use SHOW REPLICATION ACCOUNTS.
To retrieve the list of failover groups in your organization, use SHOW FAILOVER GROUPS.
When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
Drop a failover group named myfg in the source account.
DROP FAILOVER GROUP IF EXISTS myfg;
Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4