STOP DATABASE statement

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

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 database-server-name is not specified in Interactive SQL, all running servers are 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 clause Stop the database even if there are connections to the database. By default, the database is not stopped if there are connections to it.

Cloud note: This statement is not supported on tenant databases in the cloud.

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

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

None

SQL/2008 Vendor extension.

Stop the database named sample on the current server.

STOP DATABASE sample;

STOP DATABASE statement

Syntax

Parameters

Remarks

Permissions

Side effects

See also

Standards and compatibility

Example