https://community.databricks.com/t5/data-governance/is-it-possible-to-undrop-a-dropped-managed-table-any-workaround/m-p/38181#M1107 <P>Databricks now supports this via&nbsp;<A href="https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html" target="_blank">https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html</A>!</P> Fri, 21 Jul 2023 19:07:59 GMT User16602068676 2023-07-21T19:07:59Z https://community.databricks.com/t5/data-governance/is-it-possible-to-undrop-a-dropped-managed-table-any-workaround/m-p/24704#M808 Mon, 14 Jun 2021 21:53:36 GMT https://community.databricks.com/t5/data-governance/is-it-possible-to-undrop-a-dropped-managed-table-any-workaround/m-p/24704#M808 Anonymous 2021-06-14T21:53:36Z https://community.databricks.com/t5/data-governance/is-it-possible-to-undrop-a-dropped-managed-table-any-workaround/m-p/24705#M809 <P>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. </P> Mon, 21 Jun 2021 19:28:02 GMT https://community.databricks.com/t5/data-governance/is-it-possible-to-undrop-a-dropped-managed-table-any-workaround/m-p/24705#M809 Ryan_Chynoweth 2021-06-21T19:28:02Z https://community.databricks.com/t5/data-governance/is-it-possible-to-undrop-a-dropped-managed-table-any-workaround/m-p/38181#M1107 <P>Databricks now supports this via&nbsp;<A href="https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html" target="_blank">https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html</A>!</P> Fri, 21 Jul 2023 19:07:59 GMT https://community.databricks.com/t5/data-governance/is-it-possible-to-undrop-a-dropped-managed-table-any-workaround/m-p/38181#M1107 User16602068676 2023-07-21T19:07:59Z https://community.databricks.com/t5/data-governance/is-it-possible-to-undrop-a-dropped-managed-table-any-workaround/m-p/38183#M1108 <P>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&nbsp;<A href="https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html" target="_blank">https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html</A>&nbsp;for more details and examples.</P> Fri, 21 Jul 2023 19:31:22 GMT https://community.databricks.com/t5/data-governance/is-it-possible-to-undrop-a-dropped-managed-table-any-workaround/m-p/38183#M1108 vihangk1 2023-07-21T19:31:22Z