DataGrip schema introspection Follow
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.
Please sign in to leave a comment.
Try to press Ctrl+f6 on a table. I think there should be information you need.
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.
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.
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.
Again, I ask you for the screencast or at least a screenshot about the resolving problem. It will help us a lot!
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.
My answer in another thread https://intellij-support.jetbrains.com/hc/en-us/community/posts/360004271299/comments/360000619119