The named view cannot be dropped as it does not exist. To see names of existing views, query systables as follows:
SELECT tabname FROM systables WHERE tabtype = 'V'
