• I did this recently when I needed to fix a naming convention, maybe something like this would work for v+1(very simplistic):

    1. copy records in oldTable into newTable (with correct naming convention), both objects still existing (v+1).
    2. create view with same name as oldTable
    3. Drop oldTable (except we'd skip this step in the software version v+1)
    4. refactor code to point to newTable, where it references oldTable (which is really now a view)
    5. Once done, drop oldTable view. (this would happen in v+2)

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses