# List the tables for a ODBC, OLEDB or CUSTOM connection

List the tables in a database for a specific owner and for a ODBC, OLEDB or CUSTOM connection by using the [GetDatabaseTables method](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/EngineJSONAPI/Content/service-doc-getdatabasetables.htm).

## Example

[](https://help.qlik.com/en-US/sense-developer/Subsystems/EngineAPI/Content/Sense_EngineAPI/CreatingAppLoadingData/ViewDataToLoad/list-tables-for-ODBC.htm)

#### The goal is to list the tables in a database for a specific owner and for an ODBC connection.

The handle of the request is 1 because the [GetDatabaseTables method](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/EngineJSONAPI/Content/service-doc-getdatabasetables.htm) applies at app level.

The identifier of the connection is 067BA596-D4397921-6AD15864-BD08FDF7-2A09D765.

The name of the database is AdventureWorks and the name of the owner is HumanResources.

The client sends:

```
{
  "jsonrpc": "2.0",
  "id": 7,
  "method": "GetDatabaseTables",
  "handle": 1,
  "params": [
    "067BA596-D4397921-6AD15864-BD08FDF7-2A09D765",
    "AdventureWorks",
    "HumanResources"
  ]
}
```

The engine returns:

```
{
  "jsonrpc": "2.0",
  "id": 7,
  "result": {
    "qTables": [
      {
        "qName": "Department",
        "qType": "TABLE"
      },
      {
        "qName": "Employee",
        "qType": "TABLE"
      },
      {
        "qName": "EmployeeAddress",
        "qType": "TABLE"
      },
      {
        "qName": "EmployeeDepartmentHistory",
        "qType": "TABLE"
      },
      {
        "qName": "EmployeePayHistory",
        "qType": "TABLE"
      },
      {
        "qName": "JobCandidate",
        "qType": "TABLE"
      },
      {
        "qName": "Shift",
        "qType": "TABLE"
      },
      {
        "qName": "vEmployee",
        "qType": "VIEW"
      },
      {
        "qName": "vEmployeeDepartment",
        "qType": "VIEW"
      },
      {
        "qName": "vEmployeeDepartmentHistory",
        "qType": "VIEW"
      },
      {
        "qName": "vJobCandidate",
        "qType": "VIEW"
      },
      {
        "qName": "vJobCandidateEducation",
        "qType": "VIEW"
      },
      {
        "qName": "vJobCandidateEmployment",
        "qType": "VIEW"
      }
    ]
  }
}
```

The list of the tables in the AdventureWorks database for the owner HumanResources is displayed.