Dropping a table or keyspace Using the DROP command. You drop a table or keyspace using the DROP command. Procedure Drop the users table. cqlsh:demodb> DROP TABLE users; Drop the demodb keyspace. cqlsh:demodb> DROP KEYSPACE demodb;