---
name: "SLONIK_DROP_SET"
section: "7"
platform: "linux"
package: "slony1-2-doc"
version: "2.2.11-6"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/SLONIK_DROP_SET"
---

# SLONIK\_DROP\_SET(7)

Discard Slony-I replication set

## NAME

DROP SET - Discard Slony-I replication set

## SYNOPSIS

FC**DROP SET (options);**F\[0\]

## 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(p\_set\_id 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.

## SLONIK EVENT CONFIRMATION BEHAVIOUR

Slonik waits for the command submitted to the previous event node to be confirmed on the specified event node before submitting this command.

## VERSION INFORMATION

This command was introduced in Slony-I 1.0