Queries all tables on which a user has permissions 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
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,tbl002

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 is successful.

Examples

Sample requests

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

Sample success responses

XML format

<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

{
    "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.