Use the DROP IMAGE statement to remove images previously created using the CREATE TABLE IMAGE or CREATE VIEW IMAGE commands.


DROP [TABLE | VIEW] IMAGE image[, image]


You can specify single table/view images, or a list of images.

If you finish working on an image (table image or view image), and you don’t intend using it for some time, it is good practice to drop the image and so free memory for other users. Ultimately, the decision depends on how long it will take to create another table image, and how much RAM is available.


To drop the images of the PART and PARTSUPP tables, use:

DROP TABLE IMAGE part, partsupp

Alternately, you could use:

DROP IMAGE part, partsupp