Purpose
You can use this statement to drop a directory.
Note
To drop a directory, you must have the DROP ANY DIRECTORY privilege.
Syntax
DROP DIRECTORY directory_name;
Parameters
| Parameter | Description |
|---|---|
| directory_name | The name of the directory to be dropped. When you drop a directory, the associated shared file system directories will not be dropped from the database. |
Examples
Drop the sql_file_dir directory.
obclient> DROP DIRECTORY sql_file_dir;
Query OK, 1 row affected