UNDROP TABLE - Amazon Quantum Ledger Database (Amazon QLDB)

UNDROP TABLE

Use the UNDROP TABLE command to reactivate a table that you previously dropped (that is, inactivated) in your Amazon QLDB ledger. 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

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"