DROP INDEX

Overview

Deletes an index from the table.

See also: SQL Statements for MariaDB Xpand 6.1, in 6.0, and in 5.3

See also: SQL Statements for MariaDB Xpand 6.0 and in 5.3

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.

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;

CHANGE HISTORY

Release Series

History

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.