Search code examples
truncateucanaccess

UCanAccess: truncate schema support not working

any way to ucanaccess to supports HSQLtruncate schema PUBLIC and commit? it doesn't work on UCanAccess version 4.0.4

Cheers

Solution

  • UCanAccess does support several HSQLDB features as extensions to the Access SQL dialect, but it cannot support TRUNCATE TABLE and TRUNCATE SCHEMA because of the way UCanAccess synchronizes changes between the HSQLDB backing database and the Access database file.

    As stated in the HSQLDB documentation:

    TRUNCATE TABLE
    ...
    Delete all rows of a table without firing its triggers.

    TRUNCATE SCHEMA
    ...
    Performs the equivalent of a TRUNCATE TABLE ... AND COMMIT on all the table in the schema.

    UCanAccess relies on HSQLDB triggers to perform the synchronization.