Subject Re: [firebird-support] Database compress/purge
Author Svein Erling Tysvaer
Firebird keeps the space for future use, something you can verify by
inserting quite a bit of data (well, 4MB isn't all that much) without the
database growing. If you really bother to compress the database, do a
backup and restore.


At 09:41 23.07.2003 +0200, you wrote:
>I deleted all rows fromall my tables, but the database is still 4MB big.
>(It started out at only 200k)
>What command or tool do I need to use to "compress" the table, clearing all
>empty pages?