Stops a database on the specified database server.
Syntax
STOP DATABASE database-name
… [ ON engine-name ]
… [ UNCONDITIONALLY ]
Parameters
- 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
- Example 1 – stop the database named sample on
the default server:
Permissions
Requires
the SERVER OPERATOR system privilege.