Deletes a MaxCompute table.

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 DeleteTable

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

ProjectId Long Yes 101

The ID of the DataWorks workspace.

TableName String Yes table1

The name of the MaxCompute table.

EnvType Integer Yes 1

The environment of the DataWorks workspace. Valid values: 0 and 1. The value 0 indicates the development environment. The value 1 indicates the production environment.

AppGuid String No odps.test

The globally unique identifier (GUID) of the MaxCompute project. Specify the GUID in the odps.{projectName} format.

Schema String No default

The schema information of the table. You need to enter the schema information of the table if you enable the table schema in MaxCompute.

Response parameters

Parameter Type Example Description
RequestId String abcde

The ID of the request.

TaskInfo Object

The information about the task that is used to delete the table.

Status String success

The status of the task that is complete.

NextTaskId String abc1

The ID of the task that is running.

TaskId String abc

The ID of the task that is complete.

Content String success

The content of the task.

Examples

Sample requests

http(s)://[Endpoint]/?Action=DeleteTable
&EnvType=1
&ProjectId=101
&RegionId=cn-shanghai
&TableName=table1
&<Common request parameters>

Sample success responses

XML format

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

<TaskInfo>
    <Status>success</Status>
    <TaskId>abc</TaskId>
    <Content>success</Content>
    <NextTaskId>abc1</NextTaskId>
</TaskInfo>
<RequestId>abcde</RequestId>

JSON format

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

{
  "TaskInfo" : {
    "Status" : "success",
    "TaskId" : "abc",
    "Content" : "success",
    "NextTaskId" : "abc1"
  },
  "RequestId" : "abcde"
}

Error codes

HTTP status code Error code Error message Description
403 Forbidden.Access Access is forbidden. Please first activate DataWorks Enterprise Edition or Flagship Edition. The error message returned because you are not allowed to perform this operation. Activate DataWorks Enterprise Edition or DataWorks Ultimate Edition.
429 Throttling.Api The request for this resource has exceeded your available limit. The error message returned because the number of requests for the resource has exceeded the upper limit.
429 Throttling.Api.Risk The request for this resource has exceeded your daily available limit. The error message returned because the number of requests per day for the resource has exceeded the upper limit.
429 Throttling.System The DataWorks system is busy. Try again later. The error message returned because the DataWorks system is busy. Try again later.
429 Throttling.User Your request is too frequent. Try again later. The error message returned because excessive requests have been submitted within a short period of time. Try again later.
500 InternalError.System An internal system error occurred. Try again later. The error message returned because an internal error has occurred. Try again later.
500 InternalError.UserId.Missing An internal system error occurred. Try again later. The error message returned because an internal error has occurred. Try again later.

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