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.
sp_dbremove [ @dbname = ] 'database'
[ , [ @dropdev = ] 'dropdev' ]
[@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)
Execute permissions default to members of the sysadmin fixed server role for the database for which the drop will be performed.
This example removes a database named sales and all files associated with it.