sp_dbremove

Transact-SQL Reference

Transact-SQL Reference

sp_dbremove

Removes a database and all files associated with that database.

Important  This procedure is provided for backward compatibility only. For removable media databases, use sp_detach_db to remove a database from the server.

Syntax

sp_dbremove [ @dbname = ] 'database'
    
[ , [ @dropdev = ] 'dropdev' ]

Arguments

[@dbname =] 'database'

Is the name of the database to be removed. database is sysname, with a default value of NULL.

[@dropdev =] 'dropdev'

Is a flag provided for backward compatibility only and is currently ignored. dropdev has the value dropdev.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Permissions

Execute permissions default to members of the sysadmin fixed server role for the database for which the drop will be performed.

Examples

This example removes a database named sales and all files associated with it.

sp_dbremove sales

See Also

ALTER DATABASE

CREATE DATABASE

DBCC

sp_detach_db