DataGrip makes your SQL coding as easy and effective as possible. It completes keywords and identifiers, generates SQL, detects probable bugs in your SQL code and suggests the best options to fix them on the fly.
Code completion is pretty fast in DataGrip. You get a list of suggestions as you type: our main goal is zero-latency here. Completion is automatic, but you can invoke it at any moment by pressing Ctrl+Space. It is also context-aware, which means that it tries to only suggest the objects and keywords you may need at any particular moment.
Use built-in live templates to generate repetitive parts of SQL code, and create custom templates for even greater efficiency. Press Ctrl+J to see all the Live Templates.
Every live template has its own abbreviate — just type it and press Tab to paste
of the code. For example,
selw can be used for
SELECT * FROM with
DataGrip detects probable bugs in your SQL code and suggests the best options to fix them on the fly. The IDE will notify you if there are:
- Unresolved objects: invalid objects in a query;
- Ambiguous names in a query;
- Unused parameters in procedure or function;
- Mismatching number of columns in queries used in set operators;
- Mismatching number of values in
Qualify and quote
Try to select several objects and press Alt+Enter → Qualify object. If some objects are already qualified the others will be qualified to the same level.
Another intention action here: when you use keywords to name a table or column, DataGrip can quote identifiers with reserved symbols in the appropriate SQL dialect.
Since using wildcards is not recommended in many cases, DataGrip can expand it to list all columns of the table for you. In the case of conflicts, identifiers will be qualified.
DataGrip can give you information about the names and types of parameters for functions and procedures as well. To see this tooltip press Ctrl+P.
Column names tooltip for INSERT statement
To assist you in inserting valid values, the IDE hints at the name and type of corresponding columns. Invoke it by pressing Ctrl+P.
Column names hints for INSERT statement
Try enabling Settings → Editor → General → Appearance → Show parameter name hints:
DataGrip will prompt you with information about the column names in