Queries all the tables in a database.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String Yes GetAllTables

The operation that you want to perform. Set the value to GetAllTables.

DbName String Yes db001

The name of the database.

Response parameters

Parameter Type Example Description
Code String NO_SUCH_OBJECT

The error code returned.

Data Array of String tbl001

The tables returned.

Message String The database db001 does not exist

The error message returned.

RequestId String 9BEAC206-0795-4DE3-B1FD-964BEF432B23

The ID of the request.

Success Boolean false

Indicates whether the request was successful.

Examples

Sample requests

http(s)://[Endpoint]/?Action=GetAllTables
&DbName=db001
&<Common request parameters>

Sample success responses

XML format 

HTTP/1.1 200 OK
Content-Type:application/xml

<Message>The database db001 does not exist</Message>
<RequestId>9BEAC206-0795-4DE3-B1FD-964BEF432B23</RequestId>
<Data>[ tbl001,tbl002 ]</Data>
<Code>NO_SUCH_OBJECT</Code>
<Success>false</Success>

JSON format 

HTTP/1.1 200 OK
Content-Type:application/json

{
  "Message" : "The database db001 does not exist",
  "RequestId" : "9BEAC206-0795-4DE3-B1FD-964BEF432B23",
  "Data" : "[ tbl001,tbl002 ]",
  "Code" : "NO_SUCH_OBJECT",
  "Success" : "false"
}

Error codes

For a list of error codes, visit the API Error Center.