DROP INDEX command in Amazon QLDB

In Amazon QLDB, use the DROP INDEX command to delete an index on a table.

Note

To learn how to control access to run this PartiQL command on specific tables, see Getting started with the standard permissions mode in Amazon QLDB.

Syntax

DROP INDEX "indexId" ON table_name WITH (purge = true)

Note

The clause WITH (purge = true) is required for all DROP INDEX statements, and true is currently the only supported value.

The keyword purge is case sensitive and must be all lowercase.

Parameters

"indexId"

The unique ID of the index to drop, denoted by double quotation marks.

ON table_name

The name of the table whose index you want to drop.

Return value

tableId – The unique ID of the table whose index you dropped.

Examples

DROP INDEX "4tPW3fUhaVhDinRgKRLhGU" ON VehicleRegistration WITH (purge = true)