Use one of the following statements to drop a table:
Table You Want To Remove | Statement To Use |
---|---|
Permanent data table | DROP TABLE. Dropping a table does not delete the views, macros, functions or stored procedures that referenced the dropped table. You need to explicitly drop or alter the reference. You cannot drop a table defined with a trigger, hash index, or join index. First drop the index or trigger and then drop the table. |
Materialized global temporary table, before session end | DROP TEMPORARY TABLE. Analytics Database automatically drops all materialized temporary tables at session end.
|
Volatile table before session end | DROP TABLE. |
Global temporary table definition | DROP TABLE. |