Categories:: System functions (System Control)

SYSTEM$DISABLE_DATABASE_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>');

Copy

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');

Copy