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.
Example
The handle of the request is 1 because the GetDatabaseTables method 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.