Table Browsing

Answered

Unless I am missing it, I think the table browsing side of DataGrip could use improvement. I was looking for information by table: columns, data types, nullability, default values, constraints, indexes, grants and more. This post:

https://intellij-support.jetbrains.com/hc/en-us/community/posts/360000066330-DataGrip-schema-introspection?page=1#community_comment_360000606400

describes something similar. Is is true that Ctrl+F6 provides some of this data but:

a) I have to double click on each column to expand it to see the 'Not null' and 'Unique' data
b) the columns list cannot be sorted in any way
c) some important information is missing: column number, referenced by (what table(s) reference this table)

What I am looking for is really a mirror image of what Toad for Oracle offers:

https://blog.toadworld.com/toad-for-oracle-how-to-tell-what-columns-would-be-good-for-indexes

4 comments
Comment actions Permalink

Hi @Cmc555,

a) I have to double click on each column to expand it to see the 'Not null' and 'Unique' data

There are different icons for 'Not null' and 'Unique'. You can find full icon list in DataGrip help.

Additionally, you can invoke quick help option to get table definition from withing database tree by `Ctrl+Q`:

---

b) the columns list cannot be sorted in any way

Click on `Show options menu` for sorting options:

In case you need to exclude any database object type use `Filter`:

 

---

c) some important information is missing: column number, referenced by (what table(s) reference this table)

Not sure about what you need, but database tree view shows reference info:

0
Comment actions Permalink

Hello Vasily, thanks for the response, some comments:

a) I agree on the icons, but there are 16 different icons, I am trying to limit the amount of mental energy I have to expend. I also agree on the table definition with ctrl+q but if a table has many columns I would still have to look through them all. Showing them in a grid with text that is sortable makes it (a) easy to see (no mental energy involved) and (b) easy to sort to find things, (see (b) below)

b) sorry I meant this list, it would be nice to be able to sort by column name, data type, plus if it showed additional columns (nullable etc) ...

c) agree, foreign keys are there, the column number and referenced by are not. In addition Toad shows when the table was created, last DDL and more (see cap I linked to above)

0
Comment actions Permalink

Similar, here is a cap from Squirrel SQL:

 

0
Comment actions Permalink

There is an issue DBE-1843 where you can track progress.

0

Please sign in to leave a comment.