rename space argument: Rename a storage space (SQL administration API)
Use the rename space argument with the admin() or task() function to rename a dbspace, blobspace, sbspace, or extspace.
Syntax
EXECUTE FUNCTION
{
admin
| task
}
(
"rename space",
"space_name","new_name"
);
| Element | Description | Key Considerations |
|---|---|---|
| new_name | The new name of the space. | |
| space_name | The name of the dbspace, blobspace, sbspace, or extspace that you want to rename. |
Usage
This function is equivalent to the onspaces -ren command.
Example
The following example renames a dbspace named dbsp1 to dbsp2:EXECUTE FUNCTION task("rename space","dbsp1","dbsp2");