DbSchema Database Designer

DbSchema | Cassandra - How to Drop a Table?

Publish on DbSchema Blog >>>

Table of Contents

  1. Introduction
  2. Prerequisites
  3. What is Cassandra?
  4. What is cqlsh?
  5. How to Drop a Table in cqlsh
  6. What is DbSchema?
  7. How to Drop a Table in DbSchema
  8. Conclusion
  9. References


In this article, we’re going to delve into how to drop a table in both __cqlsh and __DbSchema. Whether you’re a seasoned database manager or a newcomer, you will find this guide handy for managing your databases in Apache Cassandra. Let’s dive in!


  • __Apache Cassandra` installed and running.
  • Knowledge of the __Cassandra Query Language` (CQL).
  • __DbSchema` installed and connected to your Cassandra database (for the DbSchema section).

For installation and establishing connection refer to Cassandra-How to create a Keyspace?

What is Cassandra?

Apache Cassandra is a highly scalable and distributed NoSQL database system that is designed to manage large amounts of structured data across many commodity servers. It provides high availability and fault tolerance, as well as a flexible and dynamic data model.

What is cqlsh?

cqlsh is a command-line client for interacting with Cassandra through Cassandra Query Language (CQL). This tool comes bundled with the Cassandra distribution and provides a useful way to interact with Cassandra databases.

How to Drop a Table in cqlsh

Dropping a table in Cassandra using cqlsh is quite straightforward. Here are the steps:

  1. Open cqlsh: Open your terminal and type __cqlsh`. This will launch the cqlsh interface if you have Cassandra installed and properly set up.

  2. Use your keyspace: Enter the following command to switch to your keyspace: __USE your_keyspace;`. Replace “your_keyspace” with the name of your keyspace.

  3. Drop the table: Now, you can drop your table by entering: __DROP TABLE your_table;`. Replace “your_table” with the name of your table.

Here’s an example:

USE test_keyspace;
DROP TABLE test_table;

This will drop “test_table” from the “test_keyspace” keyspace.

What is DbSchema?

DbSchema is a database designer and data management tool that provides an integrated environment for managing and deploying SQL and NoSQL databases. One of its unique features is its ability to interact with any SQL, NoSQL, or Cloud database via JDBC drivers.

How to Drop a Table in DbSchema

To drop a table in DbSchema, follow the steps outlined below:

  1. Launch DbSchema: Start the DbSchema application.

  2. Connect to your database: In the left panel, expand the database you want to interact with.

  3. Select the table: Navigate to the table you want to drop and right-click on it. This will open a context menu.

  4. Drop the table: From the context menu, click on ‘Drop Table’. A confirmation dialog will appear, confirm your action.

Remember, dropping a table will delete the table structure as well as all the data stored in it. Be sure about your decision before proceeding with this action.

Drop Tables and Visually Manage Cassandra using DbSchema

DbSchema is a Cassandra client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.

Drop Table >

Drop Table

Start the application and connect to the Cassandra database. Right-click any table header from the layout and choose Drop table.


Dropping a table in Cassandra through cqlsh or DbSchema is straightforward if you follow the steps above. This article provides a beginner-friendly guide to help you manage your databases in both interfaces.
However, be __careful` when dropping tables as this action is irreversible and can lead to loss of data.


  1. __Apache Cassandra` Official Documentation
  2. __cqlsh` User Guide
  3. __DbSchema` Official Documentation

This is a __high-level overview`, and both Cassandra and DbSchema come with extensive documentation that provides further details on managing databases. Happy database managing!

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.