Renaming and finding usages

The IDE correctly resolves all table and column references over your SQL files and allows you to rename any symbol and its usages easily.

Renaming

When you rename the symbol inside SQL, it is also renamed in all usages inside
your code.

Finding usages

Sometimes you just need to find usages inside console/sql files, DataGrip does it.

It can be a variable or parameter of the function.

It can be an alias of a table or column. The same works for a name of a CTE.

It can be a database object you have just created in the console.

If it is an existing object like table or column, it will be renamed in the datasource as well.