DROP REPLICATION

The DROP REPLICATION statement destroys a replication scheme and deletes it from the executing data store.

Required privilege

ADMIN

SQL syntax

DROP REPLICATION [Owner.]ReplicationSchemeName

Parameters

The DROP REPLICATION statement has the parameter:

Parameter	Description
`[Owner.]ReplicationSchemeName`	Name assigned to the replication scheme.

Description

Dropping the last replication scheme at a data store does not delete the replicated tables. These tables exist and persist at a data store whether or not any replication schemes are defined.

Examples

The following statement erases the executing data store's knowledge of replication scheme, r:

DROP REPLICATION r;