How to view table foreign keys (FK) in JetBrains DataGrip

Bart Gawrych - Dataedo Team Bart Gawrych 2019-09-17

Table of Contents:


    This tutorial will show you how to view foreign keys using DataGrip.

    Before both options

    From View -> Tool Windows in toolbar select Database (or press Alt + 1).

    Fig. 1. Database in toolbar

    Option 1: Table details

    In opened explorer search for table which foreign keys you want to see. You can identify foreign keys in two ways:

    • first is to look for blue key icon next to the list of table objects, right click on it and select Modify Foreign Key...

    Fig. 2. Modify Foreign Key option

    • second one is to right click on table name and select Modify Table. In new window switch to Foreign Keys tab

    Both actions opens the same window which contains all FK information like parent table, used columns and modify rules.

    Fig. 3. Foreign Keys details

    Option 2: ER Diagram

    In Database explorer find table like in previous option, but this time instead of clicking on Modify Table option in context menu, select Diagrams -> Show Visualization…

    Fig. 4. Diagrams in table context menu

    This will result in generating database diagram with this table and full chain of related tables like in example below:

    Fig. 5. Tables relation chain

    If you want to know more about any relation, unfortunately you can do this only by right click on appropriate table and selecting Refactor -> Modify table which leads to same options as in Option 1.

    Fig. 6. Refactor options in Diagram workspace

    0
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept