columns

8 rows where table_id = 4

View and edit SQL

id ▼ table_id name
9 items 4 hash
10 items 4 item
11 items 4 category_id
12 items 4 date
13 items 4 member_id
14 items 4 person_id
15 items 4 sort_order
16 items 4 record_id

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