Clever Geek Handbook

Can't delete table in Firebird

I'll open a command prompt in Ubuntu

and then enter in Firebird

, for example:

$ 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 like this:

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

If I log in again and list the tables, I see that the table still exists. So what's wrong with all of this?

EDIT

This is what the command returns set;

at the isql prompt:

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
+3


source to share


1 answer


You may have disabled autoloading DDL statements (enabled by default). To test the use of a command set;

in isql, it will list the current setting. If autoddl is off, you can install it again with SET AUTODDL ON;

or just release it commit;

after executing the DROP statement.



+1


source






More articles:


All Articles