drop blobspace argument: Drop a blobspace (SQL administration API)

Use the drop blobspace argument with the admin() or task() function to drop the specified blobspace.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"drop blobspace"------------->
                     '-task--'                        

>--,--"blobspace"--)--;----------------------------------------><

Element Description Key Considerations
blobspace The name of the blobspace to drop. Must be an existing blobspace.

Before you drop a blobspace, drop all tables that include a TEXT or BYTE column that references the blobspace.

Usage

This function is equivalent to the onspaces -d command.

Example

The following example drops the blobspace named blobspace3:

EXECUTE FUNCTION task("drop blobspace","blobspace3");

Copyright© 2019 HCL Technologies Limited