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, UNDROP DYNAMIC TABLE
Syntax¶
DROP DYNAMIC TABLE [ IF EXISTS ] <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.
Access control requirements¶
A role used to execute this operation must have the following privileges at a minimum:
Privilege |
Object |
Notes |
---|---|---|
OWNERSHIP |
The dynamic table that you want to drop. |
The USAGE privilege on the parent database and schema are required to perform operations on any object in a schema.
For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.
For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.
Usage notes¶
To drop a dynamic table, you must be using a role that has OWNERSHIP privilege on that dynamic table.
You can also drop a dynamic table using the DROP TABLE command.
When the
IF EXISTS
clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
Examples¶
Drop the dynamic table named product
:
DROP DYNAMIC TABLE product;DROP TABLE product;