DROP INDEX command in Amazon QLDB - Amazon Quantum Ledger Database (Amazon QLDB)
SyntaxParametersReturn valueExamples

DROP INDEX command in Amazon QLDB

Important

End of support notice: Existing customers will be able to use Amazon QLDB until end of support on 07/31/2025. For more details, see Migrate an Amazon QLDB Ledger to Amazon Aurora PostgreSQL.

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)