Categories:

System Functions (System Control)

SYSTEM$DISABLE_DATABASE_REPLICATION

Preview Feature — Open

The Account Replication preview is open to all accounts. To enable replication for your account, see Enabling Accounts for Replication.

Disable replication for a primary database and any secondary databases linked to it.

If a database was previously enabled for replication using ALTER DATABASE … ENABLE REPLICATION TO ACCOUNTS, database replication must be disabled before the database can be added to a replication or failover group.

Syntax

SYSTEM$DISABLE_DATABASE_REPLICATION('<db_name>');

Arguments

db_name

Specifies the identifier for the database.

Usage Notes

• Only account administrators (users with the ACCOUNTADMIN role) can execute this SQL function.

• This function must be executed from the source account with the primary database.

Examples

Disable replication for primary database mydb and any linked secondary databases.

Executed from the source account:

SELECT SYSTEM$DISABLE_DATABASE_REPLICATION('mydb');