drop

The drop statement is used to drop a database or table.

Drop DFS databases

Syntax

drop database [if exists] dbPath

Arguments

dbPath is a string indicating the path of a DFS database

Drop DFS/dimension tables

Syntax

drop table [if exists] dbPath.tableName

Arguments

dbPath is a string indicating the path of a DFS database.

tableName is a string indicating name of a DFS table or dimension table.

Drop in-memory tables

Syntax

drop table [if exists] tableName

Arguments

tableName is a string indicating the name of an in-memory table.

Examples

drop table if exists "t"

Related functions: undef, objs