DROP DATABASE statement

Description

Drops a database and its associated dbspace segment files.

Syntax

DROP DATABASE db-filename [ KEY key-spec ]

Parameters

key-spec:: A string, including mixed cases, numbers, letters, and special characters. It may be necessary to protect the key from interpretation or alteration by the command shell.

Examples

Example 1

The following statement drops database mydb.
```
DROP DATABASE mydb.db
```
The following statement drops the encrypted database marvin.db, which was created with the key is!seCret:
```
DROP DATABASE 'marvin.db' KEY 'is!seCret'
```
The following UNIX example drops the database temp.db from the /s1/temp directory.
```
DROP DATABASE '/s1/temp/temp.db'
```

Usage

The DROP DATABASE statement drops all the database segment files associated with the IQ STORE and TEMPORARY STORE before it drops the CATALOG store files.

The database must be stopped before you can drop it. If the connection parameter AUTOSTOP=no is used, you may need to issue a STOP DATABASE statement.

The db-filename you specify corresponds to the database filename you defined for the database using the CREATE DATABASE command. If you specified a directory path for this value in the CREATE DATABASE command, you must also specify the directory path for DROP DATABASE. Otherwise, Sybase IQ looks for the database files in the default directory where the server files reside.

You cannot execute a DROP DATABASE statement to drop an IQ database that has a DatabaseStart event defined for it.