Skip to main content

List tables

GET /projects/:projectid/databases/:dbid/tables

The table names in a database.

Returns the names of the tables in the database's public schema.

Authentication

  • Project API key: The credential for everything external. Created in Project Settings, bound to one project, and limited to the scopes it was granted. Format: proj.<keyId>.<secret>.
  • Required permission: databases.read on :dbid.

Path parameters

NameTypeRequiredDefaultDescription
projectidstringYes-The project id.
dbidstringYes-The database id.

Example request

curl -X GET \
-H "Authorization: proj.KEY_ID.SECRET" \
{{BASE_URL}}/projects/{{PROJECT_ID}}/databases/DATABASE_ID/tables

Responses

200

The tables in the database.

{
"tables": [
"orders",
"customers"
]
}