14.34.4 Removing Views

To remove a view, entries for that view must be deleted from the KDD_QUEUE_MASTER, KDD_QUEUE_FIL- TER, and KDD_QUEUE_ROLE_MAP tables.

Delete KDD_QUEUE_MASTER where QUEUE_SEQ_ID = <View Sequence Id>; 
Delete KDD_- QUEUE_ROLE_MAP where QUEUE_SEQ_ID = <View Sequence Id>; 
COMMIT;
Delete KDD_QUEUE_FILTER where QUEUE_SEQ_ID = <View Sequence Id>; 
Delete KDD_- QUEUE_ROLE_MAP where QUEUE_SEQ_ID = <View Sequence Id>; 
COMMIT;