DROP INDEX
DROP INDEX removes an index from Materialize.
Syntax
DROP INDEX [IF EXISTS] <index_name> [ 'CASCADE' | 'RESTRICT' ];
| Option | Description |
|---|---|
| IF EXISTS | Do not return an error if the specified index does not exist. |
| CASCADE | Remove the index and its dependent objects. |
| RESTRICT | Remove the index. (Default.) |
NOTE: Since indexes do not have dependent objects,
DROP INDEX, DROP INDEX RESTRICT, and DROP INDEX CASCADE are equivalent.
Privileges
To execute the DROP INDEX statement, you need:
- Ownership of the dropped index.
USAGEprivileges on the containing schema.
Examples
Remove an index
💡 Tip: In the Materialize Console, you can view existing indexes in the Database
object explorer. Alternatively, you can use the
SHOW INDEXES command.
Using the DROP INDEX commands, the following example drops an index named q01_geo_idx.
DROP INDEX q01_geo_idx;
If the index q01_geo_idx does not exist, the above operation returns an error.
Remove an index without erroring if the index does not exist
You can specify the IF EXISTS option so that the DROP INDEX command does
not return an error if the index to drop does not exist.
DROP INDEX IF EXISTS q01_geo_idx;