---
name: "DROP_SET"
section: "7"
platform: "linux"
package: "slony1-doc"
version: "1.2.15-1"
release: "Debian 5.0 (Lenny)"
platforms: ["linux"]
url: "https://new.carta.tech/DROP_SET"
---

# DROP\_SET(7)

Discard Slony-I replication set

## NAME

DROP SET - Discard Slony-I replication set

## SYNOPSIS

**DROP SET (options);**

## DESCRIPTION

Drop a set of tables from the Slony-I configuration. This automatically unsubscribes all nodes from the set and restores the original triggers and rules on all subscribers.

- FCID = ival F\[0\]

  ID of the set to be dropped.

- FCORIGIN = ival F\[0\]

  Current origin node of the set.

This uses “schemadocdropset( integer )” \[not available as a man page\].

## EXAMPLE

```
FC  DROP SET ( ID = 5,
             ORIGIN = 2 );
    F[0]
```

## LOCKING BEHAVIOUR

On each node, this will require taking out exclusive locks on each replicated table in order to modify the table schema to clean up the triggers and rules.

## VERSION INFORMATION

This command was introduced in Slony-I 1.0