--- In firebird-support@yahoogroups.com, "krobaz" <krobaz@y...> wrote:

> I have tried doing this a few times, each attempt has forced me to
> completely remove the entire database and start from scratch.

Others have already commented on the COMMIT issue, but while you're
experimenting with designing your database with FB (especially if you,
like me, are coming from MySQL): create an empty database, and create
a backup of it immediately after creation. This backup will be empty,
but you can restore it over the current database in whatever shape
your experiments left it to 'clean it up' and you don't have to drop
and re-create your database. I've created a small batch file that
calles gbak to restore it and 1 click gives me a clean slate. If you
get a bit further with your design, backup that, etc.

Good luck,
Emiliano