sp_dbcc_deletedb

Deletes from dbccdb all the information related to the specified target database.

Syntax

sp_dbcc_deletedb [dbname | dbid]

dbname – specifies the name of the target database for which you want the configuration information deleted. If you do not specify a value for dbname, the SAP ASE server deletes data from all databases in dbccdb..dbcc_config. If the target database is dbccdb, and dbccalt exists, the SAP ASE server deletes the data from dbccalt.
dbid – specifies the database ID number of the target database for which you want the configuration information deleted.

Example 1 – Deletes all information for the database named engdb from dbccdb:

sp_dbcc_deletedb "engdb"

All information for database engdb has been deleted from dbccdb.

There are additional considerations when using sp_dbcc_deletedb:

sp_dbcc_deletedb deletes from dbccdb all the information related to the specified target database, including configuration information and the results of previous dbcc checkstorage operations.
If the deleted database is dbccdb, and the dbccalt database exists, sp_dbcc_deletedb deletes the configuration information and results of dbccdb from dbccalt.
To remove the results of dbcc checkstorage operations created before a specific date, use sp_dbcc_deletehistory.
Using the dbid option is the only way to delete the contents of the dbccdb database for a database that has already been dropped.

The permission checks for sp_dbcc_deletedb differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the database owner of `dbccdb` (or `dbccalt`), or have the `manage checkstorage` privilege on the specified database.
Disabled	With granular permissions disabled, you must be the database owner of the specified database or have sa_role to run sp_dbcc_deletedb.