Untitled :: DataStax Astra DB Classic Documentation

Delete columns from table schema

If you find an attribute is no longer required in a table, you can remove a column. All column data will be deleted along with the column schema.

graphQL command
Result

# drop a column format from a table
mutation dropColumnFormat {
    alterTableDrop(
    keyspaceName:"library",
    tableName:"book",
    toDrop:["format"]
  )
}

{
  "data": {
    "alterTableDrop": true
  }
}