sections: introspection:tablesview
This data as json
| id | page | ref | title | content | breadcrumbs | references |
|---|---|---|---|---|---|---|
| introspection:tablesview | introspection | tablesview | /-/tables | Returns a JSON list of all tables that the current actor has permission to view. This endpoint uses the resource-based permission system and respects database and table-level access controls. The endpoint supports a ?q= query parameter for filtering tables by name using case-insensitive regex matching. Tables example : { "matches": [ { "name": "fixtures/facetable", "url": "/fixtures/facetable" }, { "name": "fixtures/searchable", "url": "/fixtures/searchable" } ] } Search example with ?q=facet returns only tables matching .*facet.* : { "matches": [ { "name": "fixtures/facetable", "url": "/fixtures/facetable" } ] } When multiple search terms are provided (e.g., ?q=user+profile ), tables must match the pattern .*user.*profile.* . Results are ordered by shortest table name first. | ["Introspection"] | [{"href": "https://latest.datasette.io/-/tables", "label": "Tables example"}] |