Docs
api
Cloud Database(UDB)
ListUDBUserTables

View the user table collection of UDB instances - ListUDBUserTables

Overview

View all user table sets of the udb instance (only includes tables with InnoDB and MyISAM engines)

Definition

Public Parameters

Parameter NameTypeDescription InformationRequired
ActionstringCorresponding API command name, the current API is ListUDBUserTables.Yes
PublicKeystringThe user’s public key can be obtained from ConsoleYes
SignaturestringUser signature generated based on public key and API command, see Signature AlgorithmYes

Request Parameters

Parameter NameTypeDescription InformationRequired
RegionstringRegion. See List of Regions and Availability ZonesYes
DBIdstringID of the UDB instanceYes

Response Field

Field NameTypeDescription InformationRequired
RetCodeintReturn status code. If it is 0, it means successful return. If it is not 0, it means failure.Yes
ActionstringOperation command name.Yes
MessagestringReturns an error message, providing detailed description when RetCode is non-zero.No
Tablesarray[UDBDatabaseData]Collection of User Database TablesYes

Data Model

UDBDatabaseData

Field NameTypeDescription InformationRequired
DBNamestringDatabase NameYes
TableDataSetarray[TableData]The collection of all tables in this libraryYes

TableData

Field NameTypeDescription InformationRequired
TableNamestringTable NameYes
DBNamestringThe name of the library to which the table belongsYes
EnginestringTable’s engine (innodb, myisam)Yes

Example

Request Example

https://api.dezai.com/?Action=ListUDBUserTables
&Region=cn-zj
&DBId=VqOTzPFh

Response Example

{
  "Action": "ListUDBUserTablesResponse",
  "RetCode": 0,
  "Tables": [
    {
      "DBName": "wqrPZnjX",
      "TableDataSet": [
        {
          "DBName": "pkuKFgfr",
          "Engine": "QKYqWolU",
          "TableName": "xHNesJxX"
        }
      ]
    }
  ]
}