DROP REPLICATION

DROP REPLICATION

Syntax

drop_replication ::=

Prerequisites

Only the SYS user can execute replication-related statements.

Description

This statement is used to drop a replication.

replication_name

This is used to specify the name of the replication to drop.

Limitation

A replication that is currently active cannot be dropped. That is, a replication cannot be dropped if the ALTER REPLICATION START command has been executed for the replication; the ALTER REPLICATION STOP command must first be executed, after which it will be possible to drop the replication.

Example

<Query> Drop the replication rep1.

iSQL> DROP REPLICATION rep1;