The DROP TEMPSPACE statement removes the definition of a temporary storage space (TempSpace) from the system catalog.
Scope |
 |
ISQL or Application Programs
SQL Syntax |
|
DROP TEMPSPACE TempSpaceName
Parameters |
|
- TempSpaceName
is the name of the TempSpace to be dropped.
Description |
|
If a TempSpace is dropped while temporary files currently exist under
the path name it specifies, those files remain until the sort
using them completes. However, no further temporary files
are created in that TempSpace.
If a TempSpace is being used by another user when the DROP TEMPSPACE statement
is issued, then the DROP statement is blocked until the TempSpace usage is finished.
Authorization |
|
You must have DBA authority to use this statement.
Example |
|
TempSpace temporary files are created in SomeGrp.SomeAcct when SQL statements require sorting.
CREATE TEMPSPACE ThisTempSpace WITH MAXFILEPAGES = 360,
LOCATION = 'SomeGrp.SomeAcct'
DROP TEMPSPACE ThisTempSpace
|
TempSpace temporary files will no longer be available in SomeGrp.SomeAcct but will be allocated in the current group and account as needed.
