Introduce Variable
Put the result of the expression, or parts of the expression, in a temporary variable with a name that explains the purpose.
More on refactoring.com
For more information see page 287 of Database Refactoring
More on refactoring.com
Architecture Refactoring
Structural Refactoring
- Drop Column
- Drop Table
- Drop View
- Introduce Calculated Column
- Introduce Surrogate Key
- Merge Columns
- Merge Tables
- Move Column
- Rename Column
- Rename Table
- Rename View
- Replace LOB With Table
- Replace Column
- Replace One-To-Many With Associative Tables
- Replace Surrogate Key With Natural Key
- Split Column
- Split Table
Data Quality Refactoring
Referential Integrity Refactoring
Transformation
Method Refactoring
- Parameterize Methods
- Remove Parameter
- Rename Method
- Reorder Parameters
- Replace Parameter with Explicit Methods
- Consolidate Conditional Expression
- Decompose Conditional
- Extract Method
- Introduce Variable
- Remove Control Flag
- Remove Middle Man
- Replace Literal with Table Lookup
- Replace Nested Conditional with Guard Clauses
- Split Temporary Variable
- Substitute Algorithm
More on refactoring.com