Replace Surrogate Key With Natural Key
Replace a surrogate key with an existing natural key.
Example
For more information see page 135 of Database Refactoring
- Refactoring
- Add CRUD Methods
- Add Foreign Key Constraint
- Add Lookup Table
- Add Mirror Table
- Add Read Method
- Add Trigger for Calculated Column
- Apply Standard Codes
- Apply Standard Type
- Consolidate Key Strategy
- Drop Column
- Drop Column Constraint
- Drop Default Value
- Drop Foreign Key Constraint
- Drop Non Nullable
- Drop Table
- Drop View
- Encapsulate Table With View
- Introduce Calculated Column
- Introduce Calculation Method
- Introduce Cascading Delete
- Introduce Column Constraint
- Introduce Common Format
- Introduce Default Value
- Introduce Hard Delete
- Introduce Index
- Introduce Read Only Table
- Introduce Soft Delete
- Introduce Surrogate Key
- Introduce Trigger for History
- Make Column Non Nullable
- Merge Columns
- Merge Tables
- Migrate Method From Database
- Migrate Method To Database
- Move Column
- Move Data
- Rename Column
- Rename Table
- Rename View
- Replace LOB With Table
- Replace Column
- Replace Method(s) With View
- Replace One-To-Many With Associative Tables
- Replace Surrogate Key With Natural Key
- Replace Type Code With Property Flags
- Replace View With Methods(s)
- Split Column
- Split Table
- Use Official Data Source
- 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
Hosted By: ThoughtWorks