Hm - well - that's a shame.

TABLE names are text - typed - they don't "change" themselves.

If you have dozens of stored procedures that are joining to this object then how do you think you can have the object name change?

By hiding the object behind a VIEW - the sprocs all use the view and you only have to change ONE PLACE.

Oh well - good luck on your quest...