For AI agents: the complete documentation index is at llms.txt. Every page is also available as markdown by appending .md to its URL, or by sending an Accept: text/markdown request header.

ALTER TABLE DEDUP DISABLE

Disables storage-level deduplication on a table. The statement removes the key columns and the mode, so new rows are stored as they arrive, including rows whose keys match stored rows. Rows already stored are not changed.

Syntax​

ALTER TABLE tableName DEDUP DISABLE;

To switch between UPSERT and SKIP, or to change the key columns, run ALTER TABLE DEDUP ENABLE with the new mode and keys instead. You don't need to disable deduplication first.

Example​

Disable deduplication on table fx_trades:

ALTER TABLE fx_trades DEDUP DISABLE;

See more examples on the deduplication page.

See also​