columns

6 rows where table_id = 452 sorted by id descending

View and edit SQL

id ▲ table_id name
1605 licensee_fts_segdir 452 root
1604 licensee_fts_segdir 452 end_block
1603 licensee_fts_segdir 452 leaves_end_block
1602 licensee_fts_segdir 452 start_block
1601 licensee_fts_segdir 452 idx
1600 licensee_fts_segdir 452 level

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 9.914ms