DROP SPATIAL INDEX

Removes a spatial index in TiDB Cloud Lake.

Syntax

DROP SPATIAL INDEX [IF EXISTS] <index> ON [<database>.]<table>

Examples

CREATE TABLE stores (
    store_id INT,
    store_name STRING,
    location GEOMETRY,
    SPATIAL INDEX location_idx (location)
) ENGINE = FUSE;

DROP SPATIAL INDEX location_idx ON stores;