mORMot Open Source

mtournay

Member

Registered: 2018-11-09

Posts: 1

truncate table

Hi

How can I truncate a table?

regards

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: truncate table

There are several Delete() ORM methods available, which could also be nested into a Batch + automatic transaction for best performance.
But nothing similar to a SQL truncate command.

So you need to run the SQL directly, depending on the underlying database engine.
For instance, for SQlite3 it is 'delete from tablename'.

What we usually do is to create a dedicated SQlite3 database for expandable tables.
Then deleting the file is enough to truncate the whole table in a very efficient way.