I did this recently when I needed to fix a naming convention, maybe something like this would work for v+1(very simplistic):
- copy records in oldTable into newTable (with correct naming convention), both objects still existing (v+1).
- create view with same name as oldTable
- Drop oldTable (except we'd skip this step in the software version v+1)
- refactor code to point to newTable, where it references oldTable (which is really now a view)
- 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