DROP DIRECTORY — drop a directory object
DROP DIRECTORY dirname
DROP DIRECTORY drop a directory object. This command takes effect only in oracle-compatible mode.
dirname
The dirname parameter indicates the name of the DIRECTORY object.
Drop directory object:
CREATE DIRECTORY aaa AS '/home/lightdb'; DROP DIRECTORY aaa;