DROP ASYNC REPLICATION
The DROP ASYNC REPLICATION statement deletes an asynchronous replication instance. When an asynchronous replication instance is deleted, the following objects are also deleted:
- automatically created streams of changes
- replicas (optionally)
Syntax
DROP ASYNC REPLICATION <name> [CASCADE]
Parameters
name— the name of the asynchronous replication instance.CASCADE— cascaded deletion of the replicas that were created for a given asynchronous replication instance.
Examples
This section contains examples of YQL statements that drop the asynchronous replication instance created with the following expression:
CREATE ASYNC REPLICATION my_replication
FOR original_table AS replica_table
WITH (
CONNECTION_STRING = 'grpcs://example.com:2135/?database=/Root/another_database',
TOKEN_SECRET_NAME = 'my_secret'
);
The following statement drops an asynchronous replication instance and the automatically created stream of changes for the original_table table, but the replica_table table is not deleted:
DROP ASYNC REPLICATION my_replication;
The following statement drops an asynchronous replication instance, the automatically created stream of changes for the original_table table, and the replica_table table:
DROP ASYNC REPLICATION my_replication CASCADE;