DROP EXTERNAL LOCATION ​

Drop an external location object.

DROP EXTERNAL LOCATION [ 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 have the correct privileges to run this command. See ON EXTERNAL object.

Example ​

premdb=> drop external location premdbs3data;
DROP EXTERNAL LOCATION