DROP SPACE [IF EXISTS] <graph_space_name>
DROP SPACE statement deletes everything in the related graph space.
You must have the
DROP privilege for the related graph space.
You can use the
IF EXISTS keywords when dropping spaces. These keywords automatically detects if the related graph space exists. If it exists, it is deleted. Otherwise, no graph space is deleted.
Other graph spaces stay unchanged.
DROP SPACE statement does not immediately remove all the files and directories from disk.
submit job compact.
NOTE: Be very careful with this statement.