DROP TABLE command in Amazon QLDB - Amazon Quantum Ledger Database (Amazon QLDB)

DROP TABLE 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 TABLE command to deactivate an existing table. You can use the UNDROP TABLE statement to reactivate it. Deactivating or reactivating a table has no effect on its documents or indexes.

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 TABLE table_name

Parameters

table_name

The name of the table to deactivate. The table must already exist and have a status of ACTIVE.

Return value

tableId – The unique ID of the table that you deactivated.

Examples

DROP TABLE VehicleRegistration