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. |