Sybase Adaptive Server Anywhere - STOP DATABASE Statement

Chapter 9 SQL Statements
625
STOP DATABASE statement
Use this statement to stop a database on the current database server.
STOP DATABASE database-name
… [ ON engine-name ]
… [ UNCONDITIONALLY ]
The required permissions are specified by the database server -gk command-
line option. This option defaults to all on the personal database server, and
dba on the network server.
You cannot use STOP DATABASE on the database to which you are
currently connected.
None
"START DATABASE statement" on page 620
"DISCONNECT statement" on page 504
"–gd command-line option" on page 26
The STOP DATABASE statement stops a specified database on the current
database server.
STOP DATABASE clause The database-name is the name of a database
(other than the current database) running on the current server.
ON clause This clause is supported in Interactive SQL only. If engine-
name is not specified in Interactive SQL, all running engines will be
searched for a database of the specified name.
When not using this statement in Interactive SQL, the database is stopped
only if it is started on the current database server.
UNCONDITIONALLY keyword Stop the database even if there are
connections to the database. By default, the database is not stopped if there
are connections to it.
♦
SQL/92 Vendor extension.
♦
Sybase Not applicable.
♦ Stop the database named
sample on the current server.
STOP DATABASE sample
Function
Syntax
Permissions
Side effects
See also
Description
Parameters
Standards and
compatibility
Examples