Delete columns in your table

Alter the schema of your database tables by removing columns using Astra’s REST API.

If you find an attribute is no longer required in a table, you can remove a column by sending a DELETE request to delete the column. All column data will be deleted along with the column schema. Use the Delete a column endpoint to remove a column from a table you created previously.

Prerequisites

  1. Generate an authorization token.

  2. Create a table in your keyspace.

Drop a single column

Drop the column email from the table users that was added in Add columns to a table.

Send a DELETE request to /api/rest/v2/schemas/keyspaces/{keyspace_name}/tables/{table_name}/columns/{column_name} to delete a column. All column data will be deleted along with the column schema.

curl -s --location \
--request DELETE http://$ASTRA_CLUSTER_ID-$ASTRA_REGION.apps.astra.datastax.com/api/rest/v2/schemas/keyspaces/users_keyspace/tables/users/columns/email \
--header "X-Cassandra-Token: $ASTRA_DB_APPLICATION_TOKEN" \
--header "Content-Type: application/json"

Note that the URL includes the keyword columns followed by the column name, in this case, email. Each column that you wish to drop must be executed with a separate command.

  1. Run the cURL call.

If the call is successful, a 204 message is returned.