====== Supported Refactorings ====== ===== Structural Refactorings ===== * [[manual/Add Column|Add Column]] * [[manual/Rename Column|Rename Column]] * [[manual/Modify Column|Modify Column]] * [[manual/Drop Column|Drop Column]] * [[manual/Alter Sequence|Alter Sequence]] * [[manual/Create Table|Create Table]] * [[manual/Rename Table|Rename Table]] * [[manual/Drop Table|Drop Table]] * [[manual/Create View|Create View]] * [[manual/Rename View|Rename View]] * [[manual/Drop View|Drop View]] * [[manual/Merge Columns|Merge Columns]] ===== Data Quality Refactorings ===== * [[manual/Add Lookup Table|Add Lookup Table]] * [[manual/Add Not-Null Constraint|Add Not-Null Constraint]] * [[manual/Remove Not-Null Constraint|Remove Not-Null Constraint]] * [[manual/Add Unique Constraint|Add Unique Constraint]] * [[manual/Drop Unique Constraint|Drop Unique Constraint]] * [[manual/Create Sequence|Create Sequence]] * [[manual/Drop Sequence|Drop Sequence]] * [[manual/Add Auto-increment|Add Auto-Increment]] * [[manual/Add Default Value|Add Default Value]] * [[manual/Drop Default Value|Drop Default Value]] ===== Referential Integrity Refactorings ===== * [[manual/Add Foreign Key Constraint|Add Foreign Key Constraint]] * [[manual/Drop Foreign Key Constraint|Drop Foreign Key Constraint]] * [[manual/Add Primary Key Constraint|Add Primary Key Constraint]] * [[manual/Drop Primary Key Constraint|Drop Primary Key Constraint]] ===== Non-Refactoring Transformations ===== * [[manual/Insert Data|Insert Data]] ===== Architectural Refactorings ===== * [[manual/Create Index|Create Index]] * [[manual/Drop Index|Drop Index]] ===== Custom Refactorings ===== * [[manual/Custom SQL|Custom SQL]] * [[manual/Custom SQL File|Execute SQL Script]] * [[manual/Custom Refactoring Class|Custom Refactoring Class]] More will be included in future releases. Suggestions for additional refactorings are always [[community|welcome]]