Blog Category Cassandra

DbSchema Blog

Cassandra ALTER TABLE Guide: What You Can and Cannot Change

Learn what ALTER TABLE actually supports in Cassandra, including adding columns, dropping columns, renaming primary-key columns, and changing table options.

• 27-May-2023

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.

• 27-May-2023

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.

• 27-May-2023

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.

• 27-May-2023

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.

• 18-May-2023

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.

• 18-May-2023