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
EXECUTE FUNCTION
{
admin
| task
}
("drop sbspace"
,
"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");