Example: Change a column name

To change the name of the SUBJECTINITIALS column to SUB_INIT in the RD_MEDHIST view:

update RT_MD_VIEWDICTIONARY set columnname='SUB_INIT' where viewname='RD_MEDHIST' and columnname='SUBJECTINITIALS';

update RD_DATADICTIONARY set rd_columnname='SUB_INIT' where rd_viewname='RD_MEDHIST' and rd_columnname='SUBJECTINITIALS';

commit;