User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To stop a database on the specified database engine

Syntax

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

Usage

ISQL

Permissions

None

Side effects

None

See also

• START DATABASE statement
• DISCONNECT statement

Description

The STOP DATABASE statement stops a specified database on a specified database engine. If engine-name is not specified, all running engines will be searched for a database of the specified 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.

Examples

Stop the database named sample on the default engine.

     STOP DATABASE sample ;