Drop Window

The DROP WINDOW command is used to remove an existing window from RioDB.

Access Rule

Requires WINDOW, STREAM, or ADMIN role.

Syntax

DROP WINDOW <window name>;

Example

DROP WINDOW last_10_bids;

Output: A JSON formatted confirmation that the window has been removed.

NOTE: A window cannot be removed if there are queries using it. There is no “force” option to cascade removals. You must first remove dependent queries before you can drop a window.