DROP DATABASE Statement

Drops a database and its associated dbspace segment files.

Syntax

DROP DATABASE db-filenameKEY key-spec ] 

Parameters

Examples

Usage

DROP DATABASE drops all the database segment files associated with the IQ store and temporary store before it drops the catalog store files.

You must stop a database 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 file name you defined for the database using CREATE DATABASE. 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.

Standards

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Not supported by Adaptive Server Enterprise.

Permissions

Required permissions are set using the database server -gu command line option. The default setting is to require DBA authority.

Related reference
CREATE DATABASE Statement
STOP DATABASE Statement [Interactive SQL]