home / fixtures

fixtures

Query actions Query actions
  • Explain this query

    Runs a SQLite explain

Test tables description

Custom SQL query returning 13 rows (hide)

This data as json, testall, testnone, testresponse, CSV

typenametbl_namerootpagesql
index sqlite_autoindex_primary_key_multiple_columns_1 primary_key_multiple_columns 4  
index sqlite_autoindex_primary_key_multiple_columns_explicit_label_1 primary_key_multiple_columns_explicit_label 6  
index sqlite_autoindex_compound_primary_key_1 compound_primary_key 8  
index sqlite_autoindex_compound_three_primary_keys_1 compound_three_primary_keys 10  
index sqlite_autoindex_foreign_key_references_1 foreign_key_references 13  
index sqlite_autoindex_sortable_1 sortable 15  
index sqlite_autoindex_Table With Space In Name_1 Table With Space In Name 19  
index sqlite_autoindex_table/with/slashes.csv_1 table/with/slashes.csv 21  
index sqlite_autoindex_complex_foreign_keys_1 complex_foreign_keys 23  
index sqlite_autoindex_custom_foreign_key_label_1 custom_foreign_key_label 25  
index sqlite_autoindex_tags_1 tags 29  
index sqlite_autoindex_searchable_tags_1 searchable_tags 32  
index sqlite_autoindex_searchable_fts_segdir_1 searchable_fts_segdir 35  
Powered by Datasette