79

Cassandra Drop Keyspace

In Cassandra, “DROP Keyspace” command is used to drop keyspaces with all the data, column families, user defined types and indexes from Cassandra.

Cassandra takes a snapshot of keyspace before dropping the keyspace. If keyspace does not exist in the Cassandra, Cassandra will return an error unless IF EXISTS is used.

Syntax:

Example:

Let’s take an example to drop the keyspace named “tutoraspire”.

DROP keyspace tutoraspire;

Verification:

After the execution of the above command the keyspace “tutoraspire” is dropped from Cassandra with all the data and schema.

You can verify it by using the “USE” command.

Now you can see that “tutoraspire” keyspace is dropped. If you use “DROP” command again, you will get the following message.

---