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.
DataGrip highlights the usages of particular objects in the current context. Note, that it is not just text search, the IDE understands what the objects are that are used in the statement
Find usages inside source codes
DataGrip lets you find the usages of objects inside the source code of other objects. For instance, you can learn in which stored procedures, functions or views your table is used. As usual, press Alt+F7 on the table name or call it from the context menu.
Aliases and variables
When you rename the symbol inside SQL, it is also renamed in all usages inside your code. To rename, press Shift+F6
If it is an existing object like table or column, it will be renamed in the datasource as well.