Example: Change a view name

To change the name of the RD_MEDHIST view to RD_MEDICAL_H:

update RT_MD_VIEWDICTIONARY set viewname='RD_MEDICAL_H' where viewname='RD_MEDHIST';

update RD_DATADICTIONARY set rd_viewname='RD_MEDICAL_H' where rd_viewname='RD_MEDHIST';

commit;