DROP TABLE
Summary
The DROP TABLE command drops the specified table from the environment.
Dropping a table deletes all existing data in the table (the data is not recoverable).
Syntax
drop table [if exists] <schema name>.<table name>; |
Parameters
|
Parameter
|
Description
|
|---|---|
[if exists] |
Throws an error an attempt is made to drop a non-existent table. |
<schema name>.<table name> |
The schema and table name. |
Details
If the table does not exist and [if exists] is not specified in the command, an error is generated.
If a table is dropped and is then referenced in an existing pipeline or step, the pipeline and step will fail to run correctly. Currently no referential checks are performed.
Examples
drop table delta.table5;drop table if exists delta.foobar; |