Blog Category Cassandra

DbSchema Blog

Cassandra ALTER TABLE Guide: What You Can and Cannot Change

What ALTER TABLE changes in Cassandra 5.0, from adding and dropping columns to table options, and what to do when you need a new column type, primary key or table name.

• 11-Sep-2026

DbSchema Blog

Cassandra CREATE TABLE Guide in cqlsh and DbSchema

Learn how to create Cassandra tables in cqlsh and DbSchema, choose partition and clustering keys, and use table options without common modeling mistakes.

• 11-Sep-2026

DbSchema Blog

Cassandra CREATE KEYSPACE Guide in cqlsh and DbSchema

Learn how to create a Cassandra keyspace in cqlsh and DbSchema, choose the right replication strategy, and pick a safe replication factor.

• 06-Sep-2026

DbSchema Blog

Cassandra DROP TABLE Guide in cqlsh and DbSchema

Learn how to drop a Cassandra table in cqlsh and DbSchema, use IF EXISTS safely, and avoid accidental data loss with backups and dependency checks.

• 06-Sep-2026

DbSchema Blog

Cassandra ALTER MATERIALIZED VIEW Guide for Safe Changes

Learn what ALTER MATERIALIZED VIEW supports in Cassandra, which changes require a drop and recreate, and how to update view options safely.

• 06-Sep-2026

DbSchema Blog

Cassandra Materialized View Guide: CREATE VIEW in cqlsh and DbSchema

Learn how to create a Cassandra materialized view, understand the CQL restrictions, and decide when a view is appropriate for a new query path.

• 06-Sep-2026