> ## Documentation Index
> Fetch the complete documentation index at: https://docs.open-metadata.org/llms.txt
> Use this file to discover all available pages before exploring further.

# List Tables

> List all tables with optional filtering and pagination

# List Tables

List all tables with optional filtering and pagination.

## Query Parameters

**database** `string`

Filter by database fully qualified name.

**databaseSchema** `string`

Filter by database schema fully qualified name.

**limit** `integer` (default: 10)

Maximum number of results to return (max: 1000000).

**before** `string`

Cursor for backward pagination.

**after** `string`

Cursor for forward pagination.

**fields** `string`

Comma-separated list of fields to include. Valid fields: `tableConstraints`, `tablePartition`, `usageSummary`, `owners`, `customMetrics`, `columns`, `sampleData`, `tags`, `followers`, `joins`, `schemaDefinition`, `dataModel`, `extension`, `testSuite`, `domains`, `dataProducts`, `lifeCycle`, `sourceHash`.

**include** `string` (default: non-deleted)

Include `all`, `deleted`, or `non-deleted` entities.

**includeEmptyTestSuite** `boolean` (default: true)

Whether to include tables with empty test suites.

```python GET /v1/tables theme={null}
from metadata.sdk import configure
from metadata.sdk.entities import Tables

configure(
    host="https://your-company.open-metadata.org/api",
    jwt_token="your-jwt-token"
)

# List with pagination
page = Tables.list(limit=50, fields=["columns", "owners", "tags"])
for t in page.entities:
    print(f"{t.fullyQualifiedName.root} ({len(t.columns or [])} columns)")

# List all with auto-pagination
all_tables = Tables.list_all(batch_size=100)
for table in all_tables:
    print(f"{table.fullyQualifiedName.root}")
```

```java GET /v1/tables theme={null}
import org.openmetadata.schema.entity.data.Table;
import org.openmetadata.sdk.models.ListParams;
import org.openmetadata.sdk.models.ListResponse;

// client is an initialized OpenMetadataClient.

// Retrieve by ID
Table table = client.tables().get(tableId);

// List tables
ListResponse<Table> result = client.tables().list(
    new ListParams()
        .setFields("columns,owners,tags")
        .setLimit(50)
);

for (Table t : result.getData()) {
    System.out.println(t.getFullyQualifiedName());
}
```

```bash GET /v1/tables theme={null}
# List all
curl "{base_url}/api/v1/tables?limit=50" \
  -H "Authorization: Bearer {access_token}"

# Filter by schema
curl "{base_url}/api/v1/tables?databaseSchema=sample_data.ecommerce_db.shopify&limit=50" \
  -H "Authorization: Bearer {access_token}"

# With fields
curl "{base_url}/api/v1/tables?databaseSchema=sample_data.ecommerce_db.shopify&fields=columns,owners,tags&limit=50" \
  -H "Authorization: Bearer {access_token}"
```

```json Response theme={null}
{
  "data": [
    {
      "id": "455e3d9d-dbbf-455e-b3be-7191daa825f3",
      "name": "agent_performance_summary",
      "fullyQualifiedName": "sample_data.ecommerce_db.shopify.agent_performance_summary",
      "description": "Summary of agent performance metrics derived from multiple tables including ssot_utilization_detail for comprehensive reporting.",
      "version": 0.1,
      "updatedAt": 1769982651320,
      "updatedBy": "admin",
      "href": "http://localhost:8585/api/v1/tables/455e3d9d-dbbf-455e-b3be-7191daa825f3",
      "tableType": "Regular",
      "columns": [
        {
          "name": "agent_id",
          "dataType": "VARCHAR",
          "dataLength": 100,
          "dataTypeDisplay": "varchar",
          "description": "Agent identifier",
          "fullyQualifiedName": "sample_data.ecommerce_db.shopify.agent_performance_summary.agent_id",
          "tags": [],
          "ordinalPosition": 1
        },
        {
          "name": "performance_score",
          "dataType": "DECIMAL",
          "dataTypeDisplay": "decimal",
          "description": "Overall performance score",
          "fullyQualifiedName": "sample_data.ecommerce_db.shopify.agent_performance_summary.performance_score",
          "tags": [],
          "ordinalPosition": 2
        }
      ],
      "owners": [],
      "databaseSchema": {
        "id": "4dd30184-009c-4792-b296-9562eaed651f",
        "type": "databaseSchema",
        "name": "shopify",
        "fullyQualifiedName": "sample_data.ecommerce_db.shopify",
        "description": "This **mock** database contains schema related to shopify sales and orders with related dimension tables.",
        "displayName": "shopify",
        "deleted": false,
        "href": "http://localhost:8585/api/v1/databaseSchemas/4dd30184-009c-4792-b296-9562eaed651f"
      },
      "database": {
        "id": "0be090de-0941-48c4-af49-a6157c91cda0",
        "type": "database",
        "name": "ecommerce_db",
        "fullyQualifiedName": "sample_data.ecommerce_db",
        "description": "This **mock** database contains schemas related to shopify sales and orders with related dimension tables.",
        "displayName": "ecommerce_db",
        "deleted": false,
        "href": "http://localhost:8585/api/v1/databases/0be090de-0941-48c4-af49-a6157c91cda0"
      },
      "service": {
        "id": "fd2193af-fe09-4366-92b7-1e0d01cd8c09",
        "type": "databaseService",
        "name": "sample_data",
        "fullyQualifiedName": "sample_data",
        "displayName": "sample_data",
        "deleted": false,
        "href": "http://localhost:8585/api/v1/services/databaseServices/fd2193af-fe09-4366-92b7-1e0d01cd8c09"
      },
      "serviceType": "BigQuery",
      "tags": [],
      "deleted": false
    }
  ],
  "paging": {
    "after": "eyJsYXN0SWQiOiI0NTVlM2Q5ZC1kYmJmLTQ1NWUtYjNiZS03MTkxZGFhODI1ZjMifQ==",
    "total": 299
  }
}
```

***

## Returns

Returns a paginated list of table objects. By default, only basic fields are included. Use the `fields` parameter to request additional data such as columns, tags, and owners.

## Response

**data** `array`

Array of table objects.

**properties**

**id** `string`

Unique identifier for the table (UUID format).

**name** `string`

Table name.

**fullyQualifiedName** `string`

Fully qualified name in format `service.database.schema.table`.

**displayName** `string`

Human-readable display name.

**tableType** `string`

Type of table, for example `Regular`, `View`, `MaterializedView`.

**databaseSchema** `object`

Reference to the parent database schema.

**service** `object`

Reference to the parent database service.

**serviceType** `string`

Type of database service.

**columns** `array`

Column definitions. Only included when `fields` contains `columns`.

**owners** `array`

List of owners. Only included when `fields` contains `owners`.

**tags** `array`

Classification tags. Only included when `fields` contains `tags`.

**paging** `object`

Pagination information.

**properties**

**total** `integer`

Total count of tables matching the query.

**after** `string`

Cursor for the next page of results.

**before** `string`

Cursor for the previous page of results.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.