DB
SQL Reference

DROP

Drop tables and transforms; how drops terminate live streaming subscribers.

DROP TABLE

DROP TABLE trades;
DROP TABLE IF EXISTS trades;

Dropping a source relation terminates any live STREAM SELECT / STREAM HISTORICAL cursor over it: in-flight subscribers drain and then receive a terminal "source relation dropped" signal rather than hanging.

DROP TRANSFORM

DROP TRANSFORM t_a;

Dropping a transform stops its pipeline and removes it from the catalog; the target table is left intact.

TODO-verify: CASCADE / dependency semantics when dropping a table that is a transform target or source. Confirm against your release.

INSERT

Insert rows into append, keyed, and attribute tables with the VALUES form.

Data types

The NYXDB type system — integers, decimals, floats, temporal, string/binary, containers, vector(N), and semantic types.

On this page

DROP TABLEDROP TRANSFORM