Is it possible to UNDROP a dropped managed table? Any workaround?

[Ryan_Chynoweth · Accepted solution]

It is not possible to undrop a managed table. When you drop a managed table it will also remove the data from cloud storage as well. If it were an unmanaged table then you could simply recreate the table because it would be persisted.

[User16602068676]

Databricks now supports this via https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html!

[vihangk1]

Starting DBR 12.1 you can run the UNDROP command to undrop a managed or external table. The table must be in Unity Catalog for this feature to work. See https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html for more details and examples.