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
http://community.borland.com to subscribe to CodeCentral).

There is also Toni Martir's IBAccess at www.ibaccess.org

>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

DROP DATABASE;

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

SQL>

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 www.ibphoenix.com
or purchase the IB Phoenix CD to get the Firebird manuals...

heLen