Example: Drop a view

To remove the RD_MEDHIST view from the RDE:

Drop view RD_MEDHIST;

delete from RT_MD_VIEWDICTIONARY where viewname='RD_MEDHIST';

delete from RD_DATADICTIONARY where rd_viewname='RD_MEDHIST';

commit;