A structural database refactoring changes the structure of a table, column or view so as to improve your database design without changing its semantics. Refactoring Example Drop Column. Remove a column from an existing table. Drop Table. Remove an existing table from the database. Drop View. Remove an existing view. Introduce Calculated Column. Introduce a new column based on calculations involving data in one or more tables. Introduce Surrogate Key. Replace an existing natural key with a surrogate key. Merge Columns. Merge two or more columns within a single table. Merge Tables. Merge two or more tables into a single table. Move Column. Migrate a table column, with all of its data, to another existing table. Rename Column. Rename an existing table column with a name that explains the purpose. Rename Table. Rename an existing table with a name that explains the purpose. Rename Table (via a view). Rename an existing table with a name that explains its purpose. Rename View. Rename an existing view with a name that explains the purpose. Replace Column. Replace an existing non key column with a new one. Replace LOB With Table. Replace a large object (LOB) column which contains structured data with a new table or in the same table. Replace One-to-Many With Associative Table. Replace a one-to-many association between two tables with an associative table. Replace Surrogate Key With Natural Key. Replace a surrogate key with an existing natural key. Split Column. Split a column into one or more columns within a single table. Split Table. Vertically split (e.g. by columns) an existing table into one or more tables.
