drop sbspace argument: Drop an sbspace (SQL administration API)

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

Syntax

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

>--,--"sbspace"--)--;------------------------------------------><

Element Description Key Considerations
sbspace The name of the sbspace to drop. The sbspace must exist.

Before you drop an sbspace, drop all tables that include a BLOB or CLOB column that references the sbspace.

Usage

This function is equivalent to the onspaces -d command.

Example

The following example drops the sbspace named sbspace3:

EXECUTE FUNCTION task("drop dbspace","sbspace3");

Copyright© 2019 HCL Technologies Limited