Reference Manual
   CHAPTER 9. SQL Statements     

STOP DATABASE statement [ISQL]

Function 

To stop a database on the specified database server.

Syntax 

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

Permissions 

The required permissions are specified by the database server -gd command-line option. This option defaults to none on the personal database server, and dba on the network server.

Side effects 

None

See also 

START DATABASE statement

DISCONNECT statement

Description 

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.

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

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not applicable.

Examples 

• Stop the database named sample on the default server.

  STOP DATABASE sample ;