Delete table¶
Delete the specified table and its data. Deletion cannot be undone.
POST https://moi.matrixorigin.cn/newmoi/catalog/table/delete
Preparation before calling¶
First Query table information to confirm the target table. Prepare the personal access token, target workspace ID, and table ID that have access to the target workspace.
The example below uses:
$AI_STUDIO_API_KEY: The actual personal access token, passed through theX-API-KeyHeader.$WORKSPACE_ID: Target workspace ID, passed throughX-Workspace-IDHeader.$TABLE_ID: Table ID to delete.
This operation deletes the table and its data irreversibly.
Request example¶
curl -X POST "https://moi.matrixorigin.cn/newmoi/catalog/table/delete" \
-H "X-API-Key: $AI_STUDIO_API_KEY" \
-H "X-Workspace-ID: $WORKSPACE_ID" \
-H 'Content-Type: application/json' \
-d '{
"id": '"$TABLE_ID"'
}'
Request body¶
Parameter |
Type |
Required |
Description |
|---|---|---|---|
|
integer |
Yes |
Table ID. |
Successful response¶
Returns 200 on success, data is null. This operation deletes the table and its data irreversibly.
{
"code": "OK",
"msg": "OK",
"data": null
}
The response fields are as follows.
Field |
Type |
Description |
|---|---|---|
|
string |
|
|
string |
|
|
null |
Fixed to |
Error response¶
{
"code": "ErrReadonlySystemDatabase",
"msg": "数据库不可写",
"data": null
}
Common HTTP errors¶
HTTP status code |
error code |
Common causes |
Recommended actions |
|---|---|---|---|
|
|
|
Pass in a valid table ID. |
|
|
The current identity does not have the permission to delete the table. |
Use credentials with write access, or contact your administrator for authorization. |
|
|
The table is located in a read-only system database. |
Select a table in a writable database. |
|
|
The service cannot delete the table. |
Record the request time and error message and try again; if it continues to fail, contact support. |
Follow-up operations¶
Query file products, confirm that the target no longer appears.