columns

6 rows where table_id = 6

descending

id ▼	table_id	name
19	items_fts_segdir 6	level
20	items_fts_segdir 6	idx
21	items_fts_segdir 6	start_block
22	items_fts_segdir 6	leaves_end_block
23	items_fts_segdir 6	end_block
24	items_fts_segdir 6	root

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE columns (
            id integer PRIMARY KEY,
            table_id integer,
            name text,
            FOREIGN KEY (table_id) REFERENCES tables(id)
        );