DROP DYNAMIC TABLE¶
Removes a dynamic table from the current/specified schema.
Syntax¶
DROP DYNAMIC TABLE <name>
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
orschema_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.