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.


Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"drop 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.


This function is equivalent to the onspaces -d command.


The following example drops the blobspace named blobspace3:

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

Copyright© 2018 HCL Technologies Limited