DROP DATABASE

Removes the virtual databases from the Querona instance.

Syntax

DROP DATABASE { database_name } [;]

Arguments

database_name

Specifies the name of the virtual database to be removed. To display a list of databases, use the sys.databases catalog view.

Remarks

Dropping a virtual database does not delete the database from the data source. it is a metadata-only operation. A physical database may be dropped manually or by using a qua_execute_provider_sql_on_connection stored procedure.

Permissions

Requires the CONTROL permission on the database, or ALTER ANY DATABASE permission, or membership in the db_owner fixed role.

Examples

The following example removes the SalesDW database.

DROP DATABASE SalesDW;