Creating and managing temporary database groups

Creating and managing temporary database groups is the same all editions of Adaptive Server.

In the Cluster Edition, the local system temporary database is not a member of the default group.

To create a temporary database group, use sp_tempdb create. For example, to create a temporary database group named tempdbgroup1:
```
sp_tempdb "create", "tempdbgroup1"
```
To drop a temporary database group, use sp_tempdb drop. For example, to drop the temporary database group named tempdbgroup1:
```
sp_tempdb "drop", "tempdbgroup1"
```
To add a database to a temporary database group, use sp_tempdb add. For example, to add database local_tempdb1 to the temporary database group named tempdbgroup1:
```
sp_tempdb "add", "local_tempdb1", "tempdbgroup1"
```
To remove a database from a temporary database group, use sp_tempdb remove. For example, to remove database local_tempdb1 from the temporary database group named tempdbgroup1:
```
sp_tempdb "remove", "local_tempdb1", "tempdbgroup1"
```

See the Reference Manual, Procedures for complete syntax and usage information for sp_tempdb.