Adding columns to a table

Adding columns to a table with the ALTER TABLE command.

The ALTER TABLE command adds new columns to a table.

Procedure

Add a coupon_code column with the varchar data type to the users table.

cqlsh:demodb> ALTER TABLE users ADD coupon_code varchar;

This creates the column metadata and adds the column to the table schema, but does not update any existing rows.

DataStax, Titan, and TitanDB are registered trademark of DataStax, Inc. and its subsidiaries in the United States and/or other countries.

Apache Cassandra, Apache, Tomcat, Lucene, Solr, Hadoop, Spark, TinkerPop, and Cassandra are trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.