GeoEco.Datasets.SQLite.SQLiteTable.DeleteIndex

SQLiteTable.DeleteIndex(indexName)

Deletes an index from the table.

If the index cannot be deleted, an appropriate exception will be raised. This can happen for a variety of reasons, which may include:

  • The index does not exist.

  • The underlying storage format or programming library used to access it does not support the deletion of indexes.

  • The table is read-only, or the caller does not have sufficient privileges to delete indexes.

Parameters:

indexName (str) –

Name of the index to delete.

Many storage formats require indexes to be named. However, if None is provided, this function will attempt to delete the index without a name, which is suitable for certain formats that only support a single index.

The name must conform to all rules imposed by the underlying storage format and programming library used to access it. The caller is expected to be aware of these rules and this function attempts to fail if any rule is violated. Certain libraries are designed to automatically modify the caller’s illegal name to a legal name. Where possible, this function overrides that behavior and tries to fail anyway.

Minimum length꞉ 1.