UNDROP TABLE - Amazon Quantum Ledger Database (Amazon QLDB)

UNDROP TABLE

Use the UNDROP TABLE statement to reactivate a table that you previously dropped (that is, inactivated) in your Amazon QLDB ledger.

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 ID of the table that you reactivated.

Examples

UNDROP TABLE "5PLf9SXwndd63lPaSIa0O6"