Do a backup. Rename the original GDB to something like MyDB.Old Then
restore the backed up DB to its original name and location.

Regards

Tim

At 09:41 AM 23/07/2003 +0200, you wrote:

>Hi!
>
>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?
>
>thanx
>Louis
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003

[Non-text portions of this message have been removed]