---
title: "GET /v1/organizations/{orgId}/database/tables/{tableName}"
method: GET
path: "/v1/organizations/{orgId}/database/tables/{tableName}"
---

# GET /v1/organizations/{orgId}/database/tables/{tableName}

`GET /v1/organizations/{orgId}/database/tables/{tableName}`

Get table schema (columns) from the org's database

## Path parameters

- `orgId` string, required
- `tableName` string, required

## Response `200`

OK

- object
  - `columns` ColumnInfo[]
    - `defaultValue` unknown
    - `name` string
    - `notNull` boolean
    - `primaryKey` boolean
    - `type` string

## Other responses

- `400` — Bad Request
- `404` — Not Found

---

[API](https://skmtc.dev/b3os/apis/b3os-workflow-api.md) · [All operations](https://skmtc.dev/b3os/apis/b3os-workflow-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/b3os/b3os-workflow-api/revisions/a8c7af3c66a1/schema)