Stops a database on the specified database server.
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:
Standards
(back to top)
- SQL—Vendor extension to ISO/ANSI SQL grammar.
- SAP Sybase Database product—Not applicable.
Permissions
(back to top)
Requires
the SERVER OPERATOR system privilege.