---
updatedAt: 2026-06-12T14:47:33.000Z
agentTools:
  projectIndex: https://docs.formant.io/llms.txt
---

# List tables with columns

Retrieves all tables with columns and data types
Resource: organization
Authorized roles: viewer

# OpenAPI definition

```json
{
  "components": {
    "schemas": {
      "SqlColumn": {
        "properties": {
          "name": {
            "type": "string"
          },
          "dataType": {
            "type": "string"
          },
          "isNullable": {
            "type": "boolean"
          },
          "tableName": {
            "type": "string"
          },
          "nativeType": {
            "type": "string"
          },
          "description": {
            "type": "string"
          }
        },
        "type": "object",
        "required": [
          "name",
          "dataType",
          "isNullable",
          "tableName"
        ]
      },
      "SqlTable": {
        "properties": {
          "name": {
            "type": "string"
          },
          "description": {
            "type": "string"
          },
          "columns": {
            "items": {
              "$ref": "#/components/schemas/SqlColumn"
            },
            "type": "array"
          }
        },
        "type": "object",
        "required": [
          "name",
          "columns"
        ]
      },
      "SqlTablesListReponse": {
        "properties": {
          "items": {
            "items": {
              "$ref": "#/components/schemas/SqlTable"
            },
            "type": "array"
          }
        },
        "type": "object",
        "required": [
          "items"
        ]
      }
    },
    "securitySchemes": {
      "bearerAuth": {
        "type": "http",
        "scheme": "bearer",
        "bearerFormat": "JWT"
      }
    }
  },
  "info": {
    "title": "Formant query-api",
    "version": "1.357.8"
  },
  "openapi": "3.0.0",
  "paths": {
    "/analytics/tables": {
      "get": {
        "operationId": "AnalyticsController.listTablesWithColumns",
        "parameters": [
          {
            "in": "header",
            "name": "app-id",
            "required": false,
            "schema": {
              "type": "string"
            }
          }
        ],
        "responses": {
          "200": {
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/SqlTablesListReponse"
                }
              }
            },
            "description": ""
          }
        },
        "summary": "List tables with columns",
        "tags": [
          "Analytics"
        ],
        "description": "Retrieves all tables with columns and data types\nResource: organization\nAuthorized roles: viewer",
        "security": [
          {
            "bearerAuth": []
          }
        ]
      }
    }
  },
  "servers": [
    {
      "url": "https://api.formant.io/v1/queries"
    }
  ]
}
```