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;