Skip to main content

Delete a column

DELETE /projects/:projectid/databases/:dbid/tables/:tblid/columns/:colid

Drop a column and its data.

Irreversible — the values in that column are gone.

Authentication

  • Project API key: The credential for everything external. Created in Project Settings, bound to one project, and limited to the scopes it was granted. Format: proj.<keyId>.<secret>.
  • Required permission: databases.schema on :dbid.

Path parameters

NameTypeRequiredDefaultDescription
projectidstringYes-The project id.
dbidstringYes-The database id.
tblidstringYes-The table name.
colidstringYes-The column to drop.

Example request

curl -X DELETE \
-H "Authorization: proj.KEY_ID.SECRET" \
{{BASE_URL}}/projects/{{PROJECT_ID}}/databases/DATABASE_ID/tables/orders/columns/total

Responses

204

Dropped. No body.

403

The key lacks the schema permission.