DROP INDEX
Removes an existing index. The default index name is table_name_column_name_idx
.
Syntax
BNF definition:
drop_index_statement::= DROP INDEX [ IF EXISTS ] index_name
DROP INDEX [ IF EXISTS ] [<keyspace_name>.]<index_name> ;
Syntax legend
Syntax conventions | Description |
---|---|
UPPERCASE | Literal keyword. |
Lowercase | Not literal. |
| Variable value. Replace with a user-defined value. |
| Optional. Square brackets ( |
| Group. Parentheses ( |
| Or. A vertical bar ( |
| Repeatable. An ellipsis ( |
| Single quotation ( |
| Map collection. Braces ( |
Set, list, map, or tuple. Angle brackets ( | |
| End CQL statement. A semicolon ( |
| Separate the command line options from the command arguments with two hyphens ( |
| Search CQL only: Single quotation marks ( |
| Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrConfig files. |
Example
Drop the index rank_idx
from the cycling.rank_by_year_and_name
table.
DROP INDEX IF EXISTS cycling.rank_idx;