My database is getting rather large and I am deleteing old records. There is one table, VIEWITEMMOVEMENTHISTORY, that has numerous records but when I try to delete the old records I get the error: UNION ALL view 'VIEWITEMMOVEMENTHISTORY' is not updatable because the definition contains a disallowed construct.
Does anyone know how to go about deleteing the records from this table?