ASA SQL Reference
  SQL Statements

STOP DATABASE statement

Description 

Use this statement to stop a database on the current database server.

Syntax 

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

Parameters 

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.

Usage 

The STOP DATABASE statement stops a specified database on the current database server.

Permissions 

The required permissions are specified by the database server -gk 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.

Side effects 

None

See also 

START DATABASE statement

DISCONNECT statement [ESQL] [Interactive SQL]

-gd server option

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not applicable.

Example 

Stop the database named sample on the current server.

STOP DATABASE sample