tables

35 rows where database_id = 13

View and edit SQL

Suggested facets: count, has_fts, is_hidden, label_column

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

CSV options:

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)
        );
Powered by Datasette · Query took 19.789ms