home / docs / sections

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"}]
Powered by Datasette · Queries took 3.097ms