Product Documentation

Appearance

EE: All cloud platforms
CE

DROP EXTERNAL FORMAT ​

Drop an external format object.

DROP EXTERNAL FORMAT [ 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.

For example:

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

The IF EXISTS option drops the object, if found, but does not return an error message if it is not found.

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