View primary key in DBeaver

dbeaver
hunger picture hunger · Feb 11, 2019 · Viewed 7.7k times · Source

Is there a quick way to view the primary key of a table in DBeaver? Like e.g. in the Eclipse data source explorer, where primary key rows are marked with "PK" and a special symbol.

Eclipse data source explorer

Answer

Anshuman Tiwari picture Anshuman Tiwari · Jun 24, 2019

For a given table, right click on the table name(in Database Navigator) -> select View Diagram.

This will open a window like this containing a single ER Diagram for the table - enter image description here

In this diagram, the primary keys can be seen marked as bold under the table name, in the second partition.

To have a look at the primary keys of all the tables, in the Database Navigator, go to your database and then right click on public -> select View diagram. This will open the ER diagram for the whole database and the connections between the tables. Here, under each table name, the bold columns are the primary keys.

Note: A primary key can be a single key as well as a combination of multiple keys.

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