---
title: "Get Table Specific Schema"
slug: "get-table-specific-schema"
updated: 2026-02-22T17:25:18Z
published: 2026-02-22T17:25:18Z
canonical: "help.symphonysummitai.com/get-table-specific-schema"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.symphonysummitai.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Get Table Specific Schema

To fetch the column names and datatypes for a specific DN Table in your database, use the **getdnSchema** API along with the specific Tablename (Example: datasource=mart_im_ticket_master). Executing the getdnSchema api will give you the column names, value, and datatypes of the table.

This output helps reporting tools understand the table structure.

To fetch the Column names and datatypes for a specific DN Table, perform the following steps:

**Steps**

1. Copy the Token generated without the comma or quotes.
2. Go to Postman or any other API tool.
3. Specify the URL as https://<novatech.com>/api_report/API/getdnSchema?datasource=mart_im_ticket_master
4. Click on **Authorization** tab and select Bearer and paste the Token.
5. Click **Send**.

**Response**

```none
[
    {
        "text": "ticket_id",
        "value": "ticket_id",
        "datatype": "bigint"
    },
    {
        "text": "ticket_no",
        "value": "ticket_no",
        "datatype": "bigint"
    },
    {
        "text": "tenant_id",
        "value": "tenant_id",
        "datatype": "varchar"
    },
]
```