drop tempdbspace argument: Drop a temporary dbspace (SQL administration API)

Use the drop tempdbspace argument with the admin() or task() function to drop the specified temporary dbspace.

Syntax

Read syntax diagramSkip visual syntax diagramEXECUTE FUNCTIONadmintask("drop tempdbspace", "tempdbspace");
Element Description Key Considerations
tempdbspace The name of the temporary dbspace to drop. The temporary dbspace must exist.

Before you drop a temporary dbspace, drop all databases and tables that you previously created in the temporary dbspace.

Usage

This function is equivalent to the onspaces -d command.

Example

The following example drops the temporary dbspace named tdbspace2:

EXECUTE FUNCTION task("drop tempdbspace","tdbspace2");