- TEMPORARY
- The table to be dropped is the materialized instance of a global temporary table.
- FOREIGN
- Optional keyword you can specify for readability when dropping a foreign table.
- database_name
- user_name
- Name of the containing database or user for the specified base table or queue table.
- table_name
- Name of the base table or queue table to be dropped.
- ALL
- Drops the base global temporary table definition and its materialized instances when other transactions are not accessing them.The time required for all open transactions accessing this object to commit may be significant.