tables

25 rows where database_id = 10

View and edit SQL

Suggested facets: count, is_hidden

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

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