Subject Re: [ib-support] help with deop command without IBConsole.
Author Helen Borrie
At 11:31 PM 26-08-02 +0000, you wrote:
>I have sorted dropping tables with isql but there is a remaining problem
>with databases. I will be happy to use any firebird utility to be rid of an
>unwanted table (though I could always use the bludgeon of ordinary file
>deleting tools')

I don't see how you could use file deleting tools to drop a table...

Have you tried

DROP TABLE atable;

You will have to remove any dependencies before you are allowed to drop it.

> > Use the isql utility.
> >
> > Btw, I think there is a IBConsole version for Linux.
>I dont think there is IBConsole for linux. But I could be wrong so If you
>are able to, let me know where to find IBConsole for linux please.

I believe there is a beta at Jeff Overcash's page on CodeCentral (go to to subscribe to CodeCentral).

There is also Toni Martir's IBAccess at

>As regards isql I have not yet seen any commands for dropping databases
>but if you have please let me know how to invoke it.

It is


It takes no parameters - you need to be logged in to the database as
sysdba, owner or root for drop database to succeed. That means starting
isql's interactive shell:

/pathtobin/isql /pathtodatabase/dbname.gdb -user sysdba -password masterkey
should bring up the interactive mode prompt


All commands in isql need a terminator (semicolon normally).

type quit; or exit; to go back to the shell.

Are you considering getting hold of the manuals? If so, you can download
the IB 6 beta manuals from the Downloads > InterBase page at
or purchase the IB Phoenix CD to get the Firebird manuals...