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;