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


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