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.


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


This function is equivalent to the onspaces -d command.


The following example drops the sbspace named sbspace3:

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

Copyright© 2020 HCL Technologies Limited