Help Center/
GaussDB/
Developer Guide(Centralized_8.x)/
SQL Reference/
SQL Syntax/
D/
DROP DIRECTORY
Updated on 2024-08-20 GMT+08:00
DROP DIRECTORY
Description
Deletes a directory.
Precautions
- When enable_access_server_directory is set to off, only the initial user is allowed to delete the directory object.
- When enable_access_server_directory is set to on, a user with the SYSADMIN permission, a directory object owner, a user granted with the DROP permission for a directory, or a user who inherits permissions from the built-in role gs_role_directory_drop can delete a directory object.
Syntax
DROP DIRECTORY [ IF EXISTS ] directory_name;
Parameters
- directory_name
Specifies the name of the directory to be deleted.
Value range: an existing directory name
- IF EXISTS
If the directory object does not exist, a NOTICE message is displayed.
Examples
-- Create a directory object. gaussdb=# CREATE OR REPLACE DIRECTORY dir as '/tmp/'; -- Delete the directory object. gaussdb=# DROP DIRECTORY dir;
Helpful Links
Parent topic: D
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot