Rename Custom View Name

Hi All ,

We have a requirement  to change the view name of a custom view  and we don't want to re-create the view  . Actually  the older view has a name starting with DBG and currently with schema extension , we could only create veiw /table staring with CCC.

 Could you please let us know if we have an existing SP in place or script which we can use to achieve this , so that the changes reflect in all the dialogtables as well.

Thanks & regards ,

Somee