truncate database cmd not found

[draveness]

co:0f1a6b81b80da80001b41d891a38ff50e6bd07cd9504377670848c5638b604ca=> TRUNCATE  test;
ERRO[0118] call RPC failed                               caller="rpcutil.go:107 rpc.(*PersistentCaller).Call" error="apply failed: execute at #0 failed: syntax error at position 9 near 'TRUNCATE'" rpc=DBS.Query stack="[#0 rpc.(*PersistentCaller).Call@rpcutil.go:107      #1 client.(*conn).sendQuery@conn.go:399      #2 client.(*conn).addQuery@conn.go:347      #3 client.(*conn).ExecContext@conn.go:249      #4 database/sql.ctxDriverExec@ctxutil.go:31      #5 database/sql.(*DB).execDC.func2@sql.go:1468      #6 database/sql.withLock@sql.go:3076      #7 database/sql.(*DB).execDC@sql.go:1463      #8 database/sql.(*DB).exec@sql.go:1448      #9 database/sql.(*DB).ExecContext@sql.go:1426     ]"
error: covenantsql: apply failed: execute at #0 failed: syntax error at position 9 near 'TRUNCATE'

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[auxten]

We use SQLite as the storage engine where TRUNCATE is not supported. Just use:
Delete from TableName
and
DELETE FROM SQLITE_SEQUENCE WHERE name='TableName';
instead.