STOP DATABASE statement [DBISQL]

Description

Stops a database on the specified database server

Syntax

STOP DATABASE database-name
... [ ON engine-name ]
... [ UNCONDITIONALLY ]

Examples

Example 1

Stop the database named sample on the default server:

STOP DATABASE sample

Usage

The STOP DATABASE statement stops a specified database on a specified database server. If engine-name is not specified, all running engines will be searched for a database of the specified name.

The database-name is the name specified in the -n parameter when the database is started, or in the DBN (DatabaseName) connection parameter. This name is typically the file name of the database file that holds the Catalog Store, without the .db extension, but can be any user-defined name

If the UNCONDITIONALLY keyword is supplied, the database will be stopped even if there are connections to the database. If UNCONDITIONALLY is not specified, the database will not be stopped if there are connections to it.

Side effects

None

Standards

SQL/92 Vendor extension.

Sybase Not applicable.

Permissions

Must have DBA authority.