Have you ever accidentally dropped a table in Databricks, or had someone else mistakenly drop it?
Databricks offers a useful feature that allows you to view dropped tables and recover them if needed.
1. You need to first execute
SHOW TABLES DROPPED
2. Then you need to UNDROP the table which you need but dropped by mistake using the below command
UNDROP TABLE { tablename | WITH ID tableid }
https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html#examples
@Sujitha
