DROP SPATIAL INDEX

删除 TiDB Cloud Lake 中的空间索引。

语法

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

示例

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;