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;