dbeaver 7.1.1 delete database

Question

How can I delete a database in Dbeaver? I set as default another db but still have an error.

Answer 1

Ok, it's not a bug. Just in your connection type another database. Now you can delete the previous default database.

Answer 2

I just had this problem with DBeaver 7.1.0.

1. Open your CLI terminal ;)

2. Type mysql -u root -p (or whatever your SQL server is, Postgres, etc)

-u root is for user root

-p is for password--it will let you type it in after you hit enter

3. Type USE databasename (where databasename is the name of your DB in DBeaver)

4. Type SHOW tables; (this will list all the tables in that DB)

5. Type DROP TABLE tablename; (where tablename is each table)

I searched for a while in DBeaver, but the easiest way is to simply use the MySQL command line interface and input a couple commands.

Answer 3

The confusion arises because DBeaver automatically selects the configured database in the connection as the default. This selection prevents the database from being deleted within its own context.

There are two parts!

1. You must need to enable "Show all databases" inside your connection properties. (Do not forget to terminate the connection first)
2. You must need to have another database usually there is one with the username i.e postgres. Otherwise create a dummy.

Once you select any other DB from the menu it will allow delete the required one!