You can use the DROP DYNAMIC TABLE statement to drop a dynamic table if you no longer use the table. This topic describes how to use the DROP DYNAMIC TABLE statement.
Syntax
Syntax for dropping a dynamic table:
DROP DYNAMIC TABLE [IF EXISTS] <schema_name>.<table_name>;Note
To drop a dynamic table, you must first drop the views or other dynamic tables that depend on the table.
Only the owner of a dynamic table can drop the table.
After you drop a dynamic table, all data refresh tasks of the table are canceled.
Examples
DROP DYNAMIC TABLE test.q1_batch;