.undo drop table command

Applies to: ✅ Azure Data Explorer

The .undo drop table command reverts a drop table operation to a specific database version. The database version must be the version just prior to the table deletion.

Permissions

You must have at least Database Admin permissions to run this command.

Syntax

.undo drop table TableName [as NewTableName] version=Version

Learn more about syntax conventions.

Parameters

Name Type Required Description
TableName string ✔️ The name of the table to restore.
NewTableName string A new table name for the table.
Version string The database version prior to the table deletion. The format is MajorVersion.MinorVersion. To find the version, see Find the required database version.

Note

The command must be executed in the context of the database from which the table was dropped.

Find the required database version

Use the .show journal command to find the database version before the drop operation was executed. For example:

.show database TestDB journal
| where Event == "DROP-TABLE" and EntityName == "TestTable"
| project OriginalEntityVersion 
OriginalEntityVersion
v24.3

Returns

This command:

  • Returns the original table extents list
  • Specifies for each extent the number of records the extent contains
  • Returns if the recover operation succeeded or failed
  • Returns the failure reason, if relevant.
ExtentId NumberOfRecords Status FailureReason
ef296c9e-d75d-44bc-985c-b93dd2519691 100 Recovered
370b30d7-cf2a-4997-986e-3d05f49c9689 1000 Recovered
861f18a5-6cde-4f1e-a003-a43506f9e8da 855 Unable to recover extent Extent container: 4b47fd84-c7db-4cfb-9378-67c1de7bf154 wasn't found, the extent was removed from storage and can't be restored

Examples

// Recover TestTable table to database version 24.3
.undo drop table TestTable version="v24.3"
// Recover TestTable table to database version 10.3 with new table name, NewTestTable (can be used if a table with the same name was already created since the drop)  
.undo drop table TestTable as NewTestTable version="v10.3"

Limitations

  • If a Purge command was executed on this database, the undo drop table command can't be executed to a version earlier to the purge execution.
  • Extent can be recovered only if the hard delete period of the extent container it resides in wasn't reached yet.
  • If a table with the same name has been created and dropped several times, only most recent drop can be undone.