Support DROP TABLE for Temporary Tables

Why it matters

This feature was created to enable users to manage temporary tables more effectively by allowing them to explicitly drop temporary tables when they are no longer needed. Previously, users could not drop temporary tables with DROP TABLE, which limited control over temporary table lifecycle management, potentially leading to resource misuse. The feature improves resource management and script flexibility.

How to use it

Use the DROP TABLE statement with the name of a temporary table to remove it explicitly. For example:

DROP TABLE temporary_table_name;

This will drop the specified temporary table if it exists in the current session or query context.