views

6 rows where database_id = 10

View and edit SQL

id ▼ database_id name
1 timezones 10 geom_cols_ref_sys
2 timezones 10 spatial_ref_sys_all
3 timezones 10 vector_layers
4 timezones 10 vector_layers_auth
5 timezones 10 vector_layers_statistics
6 timezones 10 vector_layers_field_infos

Advanced export

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

CSV options:

CREATE TABLE views (
            id integer PRIMARY KEY,
            database_id integer,
            name text,
            FOREIGN KEY (database_id) REFERENCES databases(id)
        );
Powered by Datasette · Query took 7.282ms