DROP TABLE - Amazon Quantum Ledger Database (Amazon QLDB)

DROP TABLE

Use the DROP TABLE command to inactivate an existing table in your Amazon QLDB ledger. You can use the UNDROP TABLE statement to reactivate it. Inactivating 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 inactivate. The table must already exist and have a status of ACTIVE.

Return value

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

Examples

DROP TABLE VehicleRegistration