Example: Drop a column from an existing view
To remove the SUBJECTINITIALS column from the RD_MEDHIST view:
delete from RT_MD_VIEWDICTIONARY where viewname='RD_MEDHIST' and columnname='SUBJECTINITIALS';
delete from RD_DATADICTIONARY where rd_viewname='RD_MEDHIST' and rd_columnname='SUBJECTINITIALS';
commit;