CODEWITHSUNDEEP
cassandracqlcqlsh
Brent212
Brent212

Reputation: 1874

Cassandra: Find schema name for "drop schema" command

I can't get the "drop schema" cql command to work, and I'm guessing it's because I'm not providing a schema name. No documentation available is not ambiguous about whether or not the name is necessary, since it all lumps the command description together with "drop keyspace", so while the trailing "keyspace_name" argument should be only for the "drop keyspace" flavor of the command given the name they chose, it could be that a schema name is required for the "drop schema" command. If it is, how can I find the schema name? Can't find a way to do that anywhere on the internet.

Upvotes: 0

Views: 390

Answers (1)

undefined_variable
undefined_variable

Reputation: 6228

DROP ( KEYSPACE | SCHEMA ) keyspace_name

Carefully going through document you will find that SCHEMA is an alias for KEYSPACE

You can also use the alias DROP SCHEMA.

So DROP KEYSPACE keyspace_name AND DROP SCHEMA keyspace_name is one and the same

Upvotes: 2

Related Questions