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

UNDROP 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 UNDROP TABLE command to reactivate a table that you previously dropped (that is, deactivated). 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

UNDROP TABLE "tableId"

Parameters

"tableId"

The unique ID of the table to reactivate, denoted by double quotation marks.

The table must have been previously dropped, meaning that it exists in the system catalog table information_schema.user_tables and has a status of INACTIVE. There must also be no active, existing table with the same name.

Return value

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

Examples

UNDROP TABLE "5PLf9SXwndd63lPaSIa0O6"