![STOP ENGINE statement [DBISQL]](arrow-right.gif){kind=icon}
Stops a database on the specified database server.
STOP DATABASE database-name … [ ON engine-name ] … [ UNCONDITIONALLY ]
Stop the database named “sample” on the default server:
STOP DATABASE sample
If engine-name is not specified, all running engines are searched for a database of the specified name.
The database-name is the name specified in the -n parameter when the database is started, or 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
If UNCONDITIONALLY is supplied, the database is stopped even if there are connections to the database. If UNCONDITIONALLY is not specified, the database is not stopped if there are connections to it.
None
Must have DBA authority.
