Help & DocumentationTencentDB for MySQLAPI DocumentsDatabase APIDescribeTables

DescribeTables

Last updated: 2019-11-29 16:39:26

PDF

Contents：

1. API Description

Domain name for API request: cdb.tencentcloudapi.com.

This API (DescribeTables) is used to query the database table information of a cloud database instance.

A maximum of 100 requests can be initiated per second for this API.

Note: This API supports Finance regions. Since Finance regions and non-Finance regions are isolated and not interconnected. If the common parameter Region is a Finance region (such as ap-shanghai-fsi), you need to specify a domain name containing the Finance region that should be identical to the value of Region field, for example: cdb.ap-shanghai-fsi.tencentcloudapi.com.

2. Input Parameters

The following request parameter list only provides API request parameters and some common parameters.

Parameter Name Required Type Description
Action Yes String Common parameter. The value used for this API: DescribeTables
Version Yes String Common parameter. The value used for this API: 2017-03-20
Region Yes String Common parameter.
InstanceId Yes String Instance ID, such as cdb-c1nl9rpv. It is identical to the instance ID displayed in the database console page.
Database Yes String Name of the database.
Offset No Integer Record offset. Default is 0.
Limit No Integer Number of results returned for a single request. Default is 20, and maximum is 2000.
TableRegexp No String The regular expression that matches the database table name. See MySQL website for rules.

3. Output Parameters

Parameter Name Type Description
TotalCount Integer Number of database tables that meet the condition.
Items Array of String Returned database table information.
RequestId String The unique request ID, which is returned for each request. RequestId is required for locating a problem.

4. Error Codes

The following only lists the error codes related to the API business logic.
| Error Code | Description |
|---------|---------|
| InvalidParameter | Parameter error. |
| InvalidParameter.InstanceNotFound | The instance does not exist. |

5. Example

Example 1 Query database table

Input example

https://cdb.tencentcloudapi.com/?Action=DescribeTables
&InstanceId=cdb-c1nl9rpv
&Database=mysql
&<Common request parameters>

Output example

{
  "Response": {
    "Items": [
      "CHARACTER_SETS",
      "COLLATIONS",
      "COLLATION_CHARACTER_SET_APPLICABILITY",
      "COLUMNS",
      "COLUMN_PRIVILEGES",
      "ENGINES",
      "EVENTS",
      "FILES",
      "GLOBAL_STATUS",
      "GLOBAL_VARIABLES"
    ],
    "RequestId": "6EF60BEC-0242-43AF-BB20-270359FB54A7",
    "TotalCount": 10
  }
}

6. Other Resources

Cloud API 3.0 comes with the following development tools to make it easier to call the API.