DROP REPLICATION
This statement is not supported in TimesTen Scaleout.
In TimesTen Classic:
The DROP REPLICATION
statement destroys a classic replication scheme and removes it from the executing database.
Required privilege
ADMIN
Usage with TimesTen Scaleout
This statement is not supported with TimesTen Scaleout.
SQL syntax
DROP REPLICATION [Owner.]ReplicationSchemeName
Parameters
Parameter | Description |
---|---|
|
Name assigned to the classic replication scheme. |
Description
Dropping the last replication scheme on a database does not delete the replicated tables. These tables exist and persist at a database whether any replication schemes are defined.
Examples
The following statement erases the executing database's knowledge of a classic replication scheme, r
:
DROP REPLICATION r;
See also