HyperSQL：在存储过程中删除表

I am new to HyperSQL (migrating from SQL Server to in-memory dbms for performance purposes), so please forgive me if this is a syntactical issue. When I try to execute the following query in the Database Manager, it throws an error: "Unexpected token: DROP"

我是HyperSQL的新手（出于性能目的从SQL Server迁移到内存中的dbms），所以如果这是一个语法问题，请原谅我。当我尝试在数据库管理器中执行以下查询时，它会抛出一个错误：“意外的令牌：DROP”

CREATE PROCEDURE bspTable_CleanUp(ProcesslogID INT, AlgorithmID INT)
MODIFIES SQL DATA
BEGIN ATOMIC

    DROP TABLE GlobalVariable IF EXISTS;
    ...
END;

Is it not possible to drop tables from inside stored procedures in HSQL? Or this something I shouldn't even try to be doing?

是否无法从HSQL中的存储过程中删除表？或者这个我甚至不应该尝试做的事情？

1 个解决方案

#1

The current version of HSQLDB (2.3.2) does not allow any DDL statements in stored procedures. This may be allowed in future versions.

当前版本的HSQLDB（2.3.2）不允许存储过程中的任何DDL语句。在将来的版本中可能允许这样做。