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;