Dropping an OTF Database - Teradata Vantage

Apache Iceberg and Delta Lake Open Table Format on VantageCloud Lake Getting Started

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-03
dita:mapPath
bsr1702324250454.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
bsr1702324250454

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 to drop the OTF database.