DataGrip schema introspection

How do I actually look up data/constraints/indexes of tables in DataGrip?

 

In other applications this would normally be handled by typing in the table name and then ctrl-clicking it, but that does nothing in DataGrip.

 

For visual reference, what I'm looking for is a version of this screen in DataGrip: Note the tabs for Indexes, constraints, partitions, etc.

7 comments
Comment actions Permalink

Try to press Ctrl+f6 on a table. I think there should be information you need.

0
Comment actions Permalink

It's not showing anything - I'm seeing "unable to resolve table" message though.

It seems to only be seeing the synonyms in the current schema and not the tables in the primary schema.

0
Comment actions Permalink

Ah, so you are on the synonym in the SQL editor, right? And it is not resolved to the database. Am i right? The screenshot will be very useful.

0
Comment actions Permalink

First: It resolves to a synonym to a table in another schema. I don't really care about the synonym - DataGrip should look up the info of the synonym target in the other schema.

Second: It navigates to a generated sql declaration. I'd like to see some sort of nice tabular breakdown of the table definition like the screenshot instead.

0
Comment actions Permalink

Again, I ask you for the screencast or at least a screenshot about the resolving problem. It will help us a lot!

0
Comment actions Permalink

I hate to hijack Pmagruder's post, but I too am looking for the same feature. I come from a background using Toad for Oracle and am currently using DataGrip for a class project hosted on Heroku using PostgreSQL. I find navigating the table and columns painful. Similar to what Pmagruder described, I am looking for a view like this:
https://blog.toadworld.com/toad-for-oracle-how-to-tell-what-columns-would-be-good-for-indexes
where I can easily see all columns and information about: nullability, default values, whether or not a column is used in an index, etc.

Ctrl+F6 brings up the first cap shown below, but I have to double click on each column to see the checkboxes that have nullability (for example), which is the second screen cap under the red line.

I know this information is shown in the 'Database' view for each column but I have to memorize the icons:
https://www.jetbrains.com/help/datagrip/database-tool-window.html#possible-icon-combinations-for-columns
to understand it. There is no textual way to see information. I do not even see the information in that "icon combination" link anywhere in DataGrip in order to not have to go back to the website to understand the columns.

 

0

Please sign in to leave a comment.