Refactoring is a process of improving your source code without creating a new functionality. Refactoring helps you keep your code solid and easy to maintain.
Rename database objects
Place the caret on the object the you want to rename.
Navigate to Rename dialog.(Shift+F6). If you edit an argument in the function, you can start typing a new name inline, or press Shift+F6 twice to invoke the
In the Rename dialog, type a new name for the object.
Review changes and click Refactor. To search for usages of the object name, click Preview.
Extract a variable
Place the caret on a variable in the function.
Select a part of the expression that you want to extract and press Enter.
Extract as a Common Table Expression (CTE)
CTE is a temporary result set that you can use within another SELECT, INSERT, UPDATE, or DELETE statements. In DataGrip you can extract a subquery and convert it to CTE.
Place the caret inside the subquery that you want to convert.
Preview refactoring changes
For some refactorings, DataGrip lets you preview changes before applying them.
To see potential changes, click Preview in the Refactoring Preview dialog.
Check the changes that are going to be made in the Find tool window. You can Exclude (Delete) or Remove (Ctrl+X) changes that you consider unnecessary.
Click Do Refactor (N/A) to proceed with the changes.