Skip to content
≡

Administrator

Developer

Tools

External Tools

DROP DIRECTORY

DROP DIRECTORY#

Syntax#

drop_directory ::=#

drop_directory_image160

Prerequisites#

Only the SYS user and users to whom the DROP ANY DIRECTORY system privilege has been granted can execute this statement.

Description#

This statement is used to remove a directory. Note that only the reference to the directory in the database is removed; the actual directory is not removed from the file system.

directory_name#

This is used to specify the name of the directory to drop.

Example#

<Query> Drop the directory named anti_dir1.

iSQL> DROP DIRECTORY alti_dir1;
Drop success.