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;