Code Analysis and Quick-fixes

DataGrip detects probable bugs in your SQL code and suggests the best options to fix them on the fly.

Qualifying identifiers

One of the intentions offers you to qualify identifier with the table (alias, if used), database or schema name. Identifier can be unqualified as well.

Quoting identifiers

When you use keywords to name a table or column, DataGrip can quote identifiers with reserved symbols in the appropriate SQL dialect.

Detecting unresolved objects

DataGrip analyzes your code on the fly and immediately alerts you if you use invalid objects in a query.

It also can offer to add unresolved table/column to a data source. Intention actions are invoked by Alt+Enter.

Wildcard expanding

Since using wildcards is not recommended in many cases, DataGrip can expand it to list all columns of the table for you.