Skip to main content

Delete a table

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

Drop a table and its rows.

Irreversible. Needs the schema permission, which is what makes schema changes opt-in separately from row writes.

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 to drop.

Example request

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

Responses

204

Dropped. No body.

403

The key lacks the schema permission.