tables

25 rows where database_id = 10

descending

id ▼	database_id	name	count	is_hidden
112	timezones 10	spatial_ref_sys	4924	1
113	timezones 10	spatialite_history	14	1
114	timezones 10	sqlite_sequence	3	1
115	timezones 10	geometry_columns	1	1
116	timezones 10	spatial_ref_sys_aux	4873	1
117	timezones 10	views_geometry_columns	0	1
118	timezones 10	virts_geometry_columns	0	1
119	timezones 10	geometry_columns_statistics	1	1
120	timezones 10	views_geometry_columns_statistics	0	1
121	timezones 10	virts_geometry_columns_statistics	0	1
122	timezones 10	geometry_columns_field_infos	0	1
123	timezones 10	views_geometry_columns_field_infos	0	1
124	timezones 10	virts_geometry_columns_field_infos	0	1
125	timezones 10	geometry_columns_time	1	1
126	timezones 10	geometry_columns_auth	1	1
127	timezones 10	views_geometry_columns_auth	0	1
128	timezones 10	virts_geometry_columns_auth	0	1
129	timezones 10	sql_statements_log	1	1
130	timezones 10	SpatialIndex	0	1
131	timezones 10	ElementaryGeometries	0	1
132	timezones 10	timezones	439	0
133	timezones 10	idx_timezones_Geometry	439	1
134	timezones 10	idx_timezones_Geometry_node	13	1
135	timezones 10	idx_timezones_Geometry_rowid	439	1
136	timezones 10	idx_timezones_Geometry_parent	12	1

Advanced export

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

CREATE TABLE tables (
            id integer PRIMARY KEY,
            database_id integer,
            name text,
            count integer,
            has_fts integer,
            is_hidden integer,
            label_column text,
            FOREIGN KEY (database_id) REFERENCES databases(id)
        );