The DROP DATALAKE SQL can be used to drop an existing DATALAKE. When a DATALAKE object is dropped, only the reference in the database is dropped. There are no changes to the Catalog and Object Storage contents.
Syntax
DROP DATALAKE <datalake_name>;
Example
DROP DATALAKE datalake_test;