Hi Vlad,

I didn'T follow the entire discussion, but having TRUNCATE, or simple
way to get rid of records without re-creating table would be a very
welcome addition!!!

FWIW, knowing other DBMS a bit as well, I would like to see TRUNCATE
implemented that way:

* Does not need to be transactional, although it would be nice if it
would, but I think this isn'T that easy to implement with different
scenarios like Jim and others have shown

* Shouldn't be that restrict like Oracle when it comes to FK constraints

* The user, who is able to drop a table, should be able to TRUNCATE the
table

* Table triggers should not fire


It would be great to see TRUNCATE in Firebird, because getting rid of a
large number of records in Firebird can be a pain.

Thanks!


Regards,
Thomas