DROP INDEX

Overview

Deletes an index from the table.

USAGE

Common Syntax:

DROP INDEX [IF EXISTS] <index_name> ON <table_name>

Supported Syntax:

DROP INDEX [IF EXISTS] <index_name> ON <table_name>

The IF EXIST clause is available starting with Xpand 6.

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

DROP INDEX

To delete an index for a table in the currently selected database:

DROP INDEX idx1 ON tbl1;

The built-in function DATABASE() returns the currently selected database.

To explicitly specify a database and a table from which to delete an index, use the DATABASE_NAME.TABLE_NAME notation:

DROP INDEX idx1 ON db1.tbl1;

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.09

  • Present starting in MariaDB Xpand 23.09.1.

6.1

  • Present starting in MariaDB Xpand 6.1.0.

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.1

  • Present starting in MariaDB Xpand 6.1.0.

EXTERNAL REFERENCES