DataGrip 2023.2 Help

Inlay Hints

Inlay hints are special markers that appear in the editor and provide you with additional information about your code, like the names of the parameters that a called method expects. Other types of hints inform you about annotations, method parameters, usages, and so on (depending on the language).

In inlay hints settings, you can configure what types of information you want to get in hints.

Change inlay hints appearance

  1. In the Settings dialog (Control+Alt+S), go to Editor | Color Scheme | Language Defaults, then select Inline hints.

  2. Select the inlay hint type and state, and configure the font color and effects as required.

SQL

Parameter hints

Display column names in the following blocks:

  • In INSERT values: show names of columns in INSERT statements. Works only in query consoles, not as a language injection.

    In INSERT values

  • In SELECT expressions: show names of columns in SELECT statements that have context that sets column names. For example, SELECT statements inside CREATE VIEW and INSERT. Works only in query consoles, not as a language injection.

    db_in_select_expressions
  • For * references: show names of columns for asterisk (*) references in SELECT statements that have context that sets column names For example, SELECT statements inside CREATE VIEW and INSERT. Works only in query consoles, not as a language injection.

    For asterisk references
  • For set operations (UNION, INTERSECT, EXCEPT): show names of columns in SELECT statements when they are used in set operations like UNION, INTERSECT, and EXCEPT. Works only in query consoles, not as a language injection.

    For set operations

JOIN cardinality

Display the numerical relationship between rows of one table and rows in the other. Common cardinalities include one-to-one (1<->1), one-to-many (1<->1..n), many-to-many(1..n<->1..n), and optional (0..n). The optional cardinality appears when the referring field is nullable.

You can configure inlay hints for the following types of JOIN:

  • INNER JOIN

  • LEFT JOIN

  • RIGHT JOIN

  • FULL JOIN

JOIN cardinality
Last modified: 06 September 2023