Show TOC

STOP DATABASE Statement [Interactive SQL]Locate this document in the navigation structure

Stops a database on the specified database server.

Quick Links:

Go to Parameters

Go to Examples

Go to Standards

Go to Permissions

Syntax
STOP DATABASE <database-name>
   … [ ON <engine-name> ]
   … [ UNCONDITIONALLY ]
Parameters

(back to top)

  • database-name the name specified in the -n parameter when the database is started, or specified 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.
  • engine-name if not specified, all running engines are searched for a database of the specified name.
  • UNCONDITIONALLY

    if specified, the database is stopped, even if there are connections to the database. If not specified, the database is not stopped if there are connections to it.
Examples

(back to top)

  • Example 1 stop the database named sample on the default server:
    STOP DATABASE sample
Standards

(back to top)

  • SQL—Vendor extension to ISO/ANSI SQL grammar.
  • SAP Database products—Not applicable.
Permissions

(back to top)

Requires the SERVER OPERATOR system privilege.

Related Information