Use DROP DYNAMIC TABLE to remove a dynamic table you no longer need. Dropping the table cancels all data refresh tasks for that table.
Syntax
DROP DYNAMIC TABLE [IF EXISTS] <schema_name>.<table_name>;Parameters
| Parameter | Description |
|---|---|
IF EXISTS | Optional. |
<schema_name> | The schema that contains the table. |
<table_name> | The name of the dynamic table to drop. |
Before you begin
Before dropping a dynamic table, make sure that:
All views and dynamic tables that depend on it are dropped first.
You are the owner of the table. Only the table owner can drop it.
Example
DROP DYNAMIC TABLE test.q1_batch;