---
title: "Full object detail"
method: GET
path: "/v1/tables/{name}"
tags: ["Schema"]
---

# Full object detail

`GET /v1/tables/{name}`

## Request

- Base URL: `https://api.rossdata.dev`
- URL: `https://api.rossdata.dev/v1/tables/{name}`
- Auth: none declared

Full object: columns, keys, FKs in/out, related tables, usage.

## Path parameters

- `name` string, required

## Response `200`

OK

- TableDetail: Full object detail. Additional key/relationship arrays may accompany the fields below.
  - `object` string
  - `type` 'table' | 'view' | 'procedure' | 'function'
  - `database` 'FIN' | 'MAN', nullable
  - `module` string, nullable
  - `class` string, nullable
  - `source` string
  - `counts` object
    - `columns` integer
    - `primaryKey` integer
    - `notNull` integer
    - `identity` integer
    - `computed` integer
    - `foreignKeysOut` integer
    - `foreignKeysIn` integer
  - `archiveTwin` string, nullable: Companion archive table, if any
  - `columns` Column[]
    - `position` integer
    - `name` string
    - `type` string
    - `nullable` boolean
    - `primaryKey` boolean
    - `identity` boolean
    - `default` string, nullable
    - `computedFormula` string, nullable
    - `description` string, nullable
    - `validValues` string, nullable: Enumerated valid values, when documented
    - `notes` string, nullable
    - `foreignKey` object, nullable: FK target if this column references another table
      - `table` string
      - `column` string

## Other responses

- `404`: No object with that name

---

[API](https://skmtc.dev/rossdata/apis/rossdata-dev-api.md) · [All operations](https://skmtc.dev/rossdata/apis/rossdata-dev-api/llms.txt) · [OpenAPI document](https://skmtc.dev/rossdata/apis/rossdata-dev-api/revisions/8c796f2e258c?raw)