The DROP DATABASE SQL for an OTF data lake database removes the database metadata information in the OTF catalog for the database. Use 2-level dot notation to specify the datalake database: <datalake_name.otf_database_name>.
Syntax
DROP DATABASE <datalake_name>.<OTFdatabase_name>; <datalake_name> ::= !! name of the data lake object <OTFdatabase_name> ::= !! name of the database in the OTF catalog
Example
DROP DATABASE datalake_glue.MyDatabase;
Usage Considerations
The database must be empty (all tables with their data have been deleted) to drop the OTF database.