How do I run arbitrary SQL on DBeaver?

dbeaver
Tim B picture Tim B · Dec 30, 2015 · Viewed 15k times · Source

Ok, so this may seem like a stupid question but I'm fighting DBeaver and so far it's winning and Google is refusing to pick a side.

I've worked out how to explore the database, view the structure of tables, I can even view the data of a table and filter it.

But if I just want to run an arbitrary SQL statement how do I do that?

Answer

Tim B picture Tim B · Dec 30, 2015

And 30 seconds after posting I found the answer. There is an SQL Editor menu appeared at the top of the screen (not in the Database Navigator). Selecting SQL Editor from that brings up a query window I can type SQL into.

Related questions

How to execute a SQL script in DBeaver?

I have a number of .sql files that I wish to execute through DBeaver. Traditional database development programmes allow the user to edit and run SQL scripts (totally or partially) in the same window, but this is not obvious with …

Read More
Export result set on Dbeaver to CSV

Normally I use Dbeaver for windows and always export my result set like this: Run my query --> select the result --> export the result set --> select export to clipboard --> done This step by …

Read More
Recover DB password stored in my DBeaver connection

I forgot the password of a dev instance (irresponsible.. yeah, I am working on it). I have the connection saved in my DBeaver with the password. I am still able to connect using that connection. DBeaver is not showing it …

Read More