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;
Parent topic: Creating a custom RDE