Change: ‘dropSpatialIndex’

Drops an existing spatial index.

Available Attributes

Attribute Description Required For Supports
catalogName The name of the catalog. all
schemaName The name of the schema. all
tableName The name of the indexed table. h2, derby, mysql all
indexName The name of the index to drop. mysql, oracle, postgresql mysql, oracle, postgresql

Example

<changeSet id="1" author="bob">
   <spatial:dropSpatialIndex tableName="home" indexName="home_location_idx"/>
</changeSet>

Database Support

Database Notes Auto Rollback
Derby Supported No
H2 Supported No
MySQL Supported No
Oracle Supported No
PostgreSQL Supported No