columns

6 rows where table_id = 6

View and edit SQL

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

CSV options:

CREATE TABLE columns (
            id integer PRIMARY KEY,
            table_id integer,
            name text,
            FOREIGN KEY (table_id) REFERENCES tables(id)
        );
Powered by Datasette · Query took 10.446ms