Product Documentation

Appearance

DROP EXTERNAL STORAGE ​

Drop an external storage object.

DROP EXTERNAL STORAGE [ IF EXISTS ] name [ CASCADE ]
IF EXISTS
Drop the object, if found, but do not return an error message if it is not found.
CASCADE
Drop dependent objects as well, if any exist. You must use CASCADE to drop an external storage object that has a dependent external location.

You must have the correct privileges to run this command. See ON EXTERNAL object.

Example ​

premdb=> drop external storage premdbs3;
ERROR:  cannot drop external storage premdbs3 because other objects depend on it
DETAIL:  external location premdbs3data depends on external storage premdbs3
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
premdb=> drop external storage premdbs3 cascade;
DROP EXTERNAL STORAGE

Parent topic:SQL Commands