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