Unable to drop table in Firebird

Question

I open a command prompt in Ubuntu and then log in to Firebird, like so:

$ isql-fb
SQL> connect "localhost:/var/lib/firebird/2.5/data/reestr.fdb" user 'SYSDBA' password 'root';

Then I list all tables in my database:

 > show tables;
   ARCHIVE_1_    ...
   ...
   ...

Finally, I want to drop one table. I try it this way:

> DROP TABLE ARCHIVE_1_;
........ absolutely no reaction, propmt is waiting for something

If I log in again and list tables, I see that the table is still there. So, what is wrong with all that?

EDIT

This is what set; command in isql prompt returns:

Print statistics:        OFF
Echo commands:           OFF
List format:             OFF
List Row Count:          OFF
Select rowcount limit:   0
Autocommit DDL:          ON
Access Plan:             OFF
Access Plan only:        OFF
Display BLOB type:       1
Column headings:         ON
Terminator:              ;
Time:                    OFF
Warnings:                ON
Bail on error:           OFF

Answer 1

It could be that you have turned off autocommit of DDL statements (the default is on). To check use set; command in the isql, it'll list the current setup. If the autoddl is off then you can set it on again using SET AUTODDL ON; or just issue commit; after you'r DROP statement.