Skip to content

rename-table (US022)#

Automatic fix is not available.

What it does#

Checks renaming of table.

Why not?#

Renaming a table can easily break applications that rely on the table.

If any part of the application code, database procedures, views, or reports use the table, renaming it will cause errors and potentially disrupt business operations.

When should you?#

If the table is no longer being accessed by clients, probably after migrating clients to a new table.

Use instead:#

  1. Create a new table with the new name.
  2. Start writing data to the new table.
  3. Copy all data from the old table to the new table.
  4. Migrate clients to the new table.