Reference Manual
   CHAPTER 9. SQL Statements     

DROP DATABASE statement

Function 

To delete a database file and the associated transaction log.

Syntax 

DROP DATABASE file-name

Permissions 

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

The file must not be in use in order to be deleted.

Not supported on Windows CE.

Side effects 

In addition to deleting the database file from disk, the associated transaction log file is deleted.

See also 

CREATE DATABASE statement

Description 

The DROP DATABASE statement physically deletes the database file from disk. The statement can be used in SQL scripts that create databases, to make sure there is no database file in the place where it is to be created.

If the file does not exist, an error is generated.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not supported by Adaptive Server Enterprise.

Examples 

• Drop the database temp.db, in the C:\temp directory..

  DROP DATABASE 'c:\temp\temp.db'