Now, I want to rename the raster table and I would like to know the affected tables and the required changes to be done without affecting the functionality of the raster/overviews.
While you may get a response here the PostGIS project appears to host its own mailing lists and you might find you get a faster/better response if you ask this very product specific question over there.