there was an error in the sentence it should have read ..to be rid of an
unwanted database. The pror sentence also said I had sorted how to drop a
table..

On Monday 26 August 2002 23:56, Helen Borrie wrote:
> 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
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/