Alter a table

There are a number of alterations that can be made to tables after they have been created. Any non-partition key columns can be added, renamed, or deleted, using any CQL data type. In addition, the table properties can be modified.

These commands require a keyspace and a table.

Alter table columns

See Alter columns.

Alter table properties

Use ALTER TABLE to add or change table properties.

This example alters a table by changing the caching property:

ALTER TABLE cycling.comments WITH caching = {
  'keys' : 'NONE', 
  'rows_per_partition' : 10
};

Alter a table

Alter table columns

Alter table properties

Was this helpful?

Give Feedback