DROP DYNAMIC TABLE

Removes a dynamic table from the current/specified schema.

See also:

CREATE DYNAMIC TABLE, ALTER DYNAMIC TABLE, DESCRIBE DYNAMIC TABLE, SHOW DYNAMIC TABLES

Syntax

DROP DYNAMIC TABLE <name>
Copy

Parameters

name

Specifies the identifier for the dynamic table to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive (e.g. "My Object").

If the table identifier is not fully-qualified (in the form of db_name.schema_name.table_name or schema_name.table_name), the command looks for the table in the current schema for the session.

Usage Notes

  • To drop a table, you must be using a role that has OWNERSHIP privilege on the table.

Examples

Drop the dynamic table named product:

DROP DYNAMIC TABLE product;
Copy