Skip to content

DROP SPACE

DROP SPACE [IF EXISTS] <graph_space_name>

The 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.

The DROP SPACE statement does not immediately remove all the files and directories from disk. Use another space, and submit job compact.

NOTE: Be very careful with this statement.


Last update: March 26, 2021