tables

35 rows where database_id = 13

descending

id ▼	database_id	name	count	has_fts	is_hidden	label_column
425	wtr 13	spatial_ref_sys	4924	0	1
426	wtr 13	spatialite_history	13	0	1
427	wtr 13	sqlite_sequence	1	0	1
428	wtr 13	geometry_columns	1	0	1
429	wtr 13	spatial_ref_sys_aux	4873	0	1
430	wtr 13	views_geometry_columns	0	0	1
431	wtr 13	virts_geometry_columns	0	0	1
432	wtr 13	geometry_columns_statistics	1	0	1
433	wtr 13	views_geometry_columns_statistics	0	0	1
434	wtr 13	virts_geometry_columns_statistics	0	0	1
435	wtr 13	geometry_columns_field_infos	0	0	1
436	wtr 13	views_geometry_columns_field_infos	0	0	1
437	wtr 13	virts_geometry_columns_field_infos	0	0	1
438	wtr 13	geometry_columns_time	1	0	1
439	wtr 13	geometry_columns_auth	1	0	1
440	wtr 13	views_geometry_columns_auth	0	0	1
441	wtr 13	virts_geometry_columns_auth	0	0	1
442	wtr 13	sql_statements_log	0	0	1
443	wtr 13	SpatialIndex	0	0	1
444	wtr 13	ElementaryGeometries	0	0	1
445	wtr 13	KNN	0	0	0
446	wtr 13	licensee	28936	1	0	name
447	wtr 13	product	63	0	0	name
448	wtr 13	license	79116	0	0
449	wtr 13	license_frequency	371188	1	0
450	wtr 13	licensee_fts	28936	1	1
451	wtr 13	licensee_fts_segments	122	0	1
452	wtr 13	licensee_fts_segdir	2	0	1
453	wtr 13	licensee_fts_docsize	28936	0	1
454	wtr 13	licensee_fts_stat	1	0	1	value
455	wtr 13	license_frequency_fts	371188	1	1
456	wtr 13	license_frequency_fts_segments	1110	0	1
457	wtr 13	license_frequency_fts_segdir	10	0	1
458	wtr 13	license_frequency_fts_docsize	371188	0	1
459	wtr 13	license_frequency_fts_stat	1	0	1	value

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)
        );