---
title: "Get Table Schema"
method: GET
path: "/api/database/tables/{tableName}/schema"
tags: ["Admin"]
---

# Get Table Schema

`GET /api/database/tables/{tableName}/schema`

## Path parameters

- `tableName` string, required

## Response `200`

Table schema

- object
  - `table_name` string
  - `columns` object[]
    - `name` string
    - `type` string
    - `nullable` boolean
    - `unique` boolean
    - `default` string, nullable
    - `isPrimaryKey` boolean
  - `foreignKeys` ForeignKeyConstraint[] — Table-level foreign key constraints (one entry per constraint)
    - `constraintName` string — Constraint name. Returned when reading the schema; derived by the backend on create.
    - `referenceTable` string, required — Table being referenced
    - `referenceColumns` object[], required — Ordered (source → reference) column pairs
      - `sourceColumn` string, required — Column in the current table
      - `referenceColumn` string, required — Column in the referenced table
    - `onDelete` 'CASCADE' | 'SET NULL' | 'SET DEFAULT' | 'NO ACTION' | 'RESTRICT', required
    - `onUpdate` 'CASCADE' | 'SET NULL' | 'SET DEFAULT' | 'NO ACTION' | 'RESTRICT', required

## Other responses

- `404` — Table not found

---

[API](https://skmtc.net/insforge/apis/insforge-authentication-api.md) · [All operations](https://skmtc.net/insforge/apis/insforge-authentication-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/insforge/insforge-authentication-api/versions/a935bb49f932/schema)